Download TXT file to SQL Server

I am trying to import a txt file into SQL server using the DTS Wizard. However my file has nearly 1800 columns and the Wizard will only let me import 1024. Is there a way I can split the file for import or get the Wizard to do it for me?
bpfsrAsked:
Who is Participating?
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
As per http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Columns per base table  1,024

So you will not be able to import this without splitting it, so that is correct.
So to split it, you would have to split it vertically and you may be able to do that if you opened it in Excel and only save out 900 columns in each import and then import them into SQL.

Ben.

 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.