Hi,
Does anybody knows how to import a fixed field length data file to a SQL Server table(from Query Analyzer!)??
I tried using "BULK INSERT" but it seems not to support fix length field data files.


God Bless you,
Hossein

__________________
Be Sure,
-hossrad

can you be more specific about the fixed length data type,
where is coming from (ascii,.txt, access, foxpro..etc)


Jaime E. Maccou

Hi,
I mean files with fixed field length like this :
1-ID 4 char
2-Name 15 char
3-FName 25 char
and so on ....
and they dont hava a delimeter like tab or comma or ...


God Bless you,
Hossein

using DTS make a transform task. You should know base on the start and finish of your file the file definition.
count beginning with your first column the number of characters from beginning to end, then start from the end of the first the beginning of the second and so on.

Right click on the file (source)properties and then select your delimiter (tab,:,; ",'|) and then transform your file to its destination. Since you said there is no delimiter in the original file you may have some additional clean up to do on the database table.

Jaime E. Maccou