By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Fixed Width File Spec for SQL Server

P: 72
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.
Feb 19 '09 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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
Feb 19 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.