Hojoformo
asked on
How to import a text file into SQL Server using the Import WIZARD.
How to import a text file into SQL Server using the Import WIZARD. I have a text file and I want to load the file into a SQL table using the SQL Table Import Wizard.
Here is a SQL 2000 tutorial video....
http://www.learndts.com/VideoTutorials/DTS-Training-Video/538/Importing-Text-Files-Into-SQL-Server-Table-Using-Import.aspx
Best thing is to just go through the wizard frist and then trouble shoot the errors if any.
http://www.learndts.com/VideoTutorials/DTS-Training-Video/538/Importing-Text-Files-Into-SQL-Server-Table-Using-Import.aspx
Best thing is to just go through the wizard frist and then trouble shoot the errors if any.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What does you text file look like? (I.e., is it a comma separated file, a fixed format file, or what?)
What problems are you having? (Have you tried and there are data errors? Have you tried and there is some of the rows of text don't have enough columns? Or What?)