Fixed Width File Spec for SQL Server

Hi,

Quick question, I have a fixed width text file with over 1000 fields in it that I need to get into SQL Server 2000 (I have both enterprise manager and management studio).

I have an excel spreadsheet with the complete list of all the fields, plus start, end, and length.

Rather than manually specifying all these columns, can I use the spreadsheet data somehow to speed this up?

Regards,
Rob.

re: Fixed Width File Spec for SQL Server

I don't know how your excel sheet looks like. But you can use that and convert it to a format file. Read more about it here

-- CK