jwcolby
jwcolby at colbyconsulting.com
Fri Mar 23 11:36:20 CDT 2012
Guys, I got a database today which I suspect is a flat file, fixed width, pad right. I got a "table definition file" with hundreds of lines like: 365,Physical_Address_Results,varchar(50) Which is basically column number, field name, data type. Is there anything built in to SQL Server to take such a table definition file and create the table from it? Once created, something to pull the fixed width file into such table? The file itself is 270 GIGABYTES with a .txt extension. I am having a problem even seeing the contents. I imagine I can open it in SQL Server directly in the import wizard but I really don't want to have to manually go set up the fixed width import stuff from inside of that wizard. -- John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it