Importing from flat file

I want to transfer Data from PowerHouse (I create a text file, extention .PSD) to my SQL server. Is it possible to create a link server or a stored proc that will read this text file ???
Is someone can help me ???


This is my Flat File:

20+050729RR F930128+930128


This is the difinition of the datas

Element COM-NO Character Size 2 &
Heading "# Cie"

Element CVT-NO Numeric Size 6&
Significance 6 &
Picture "^^^^^^" &
Heading "Commande"

Element CVT-TYPE Character Size 1 &
Heading "Cvt^Type"

Element CVT-NATURE Character Size 1 &
Heading "Nature"

Element CVT-BOOK Character Size 1 &
Heading "booking"

Element CVT-FP Character Size 1 &
Heading "Cvt^Fp"

Element CVT-EXPEDITEUR Character Size 20 &
Heading "Cvt Expediteur"

Element CFO-CODE Character Size 1 &
Heading "Cfo^Code"

Element CVT-DATE-PRIX Date Size 6 &
Separator "/" Format YYMMDD &
Heading "Date Prix"

Try using DTS to import the data into SQL Server.

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

...or the BCP.EXE utility.

Nathan H.O.
Moderator
SQL-Server-Performance.com