I wonder what is the best way to import data from fixed length record text file into SQL.

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?

Thanks in advance.

WL