>I wonder what is the best way to import data from fixed length record text file into SQL.
>SQL Server 2000 DTS supports text format import.
>I have data in many fixed length ASCII files. I want to have a program to import/export them. Since SQL does not seem to direct support fixed length, do I have to define a format file?
>Another possibility is to make your own program reading text file according your rules and sending data to SQL through ODBC or ADO connection.

Thanks for the reply. But the problem I have is that I have MANY fixed length record files and they have different length. DTS is kind of inconvenient as I need to define the record layout every time for every file. I wonder whether there is some way similar to Bulk Insert for delimited text file to handle the fixed length file.