Fixed Width File Spec for SQL Server

[peridian]

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.

[ck9663]

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