Link to home
Start Free TrialLog in
Avatar of Hojoformo
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.
Avatar of 8080_Diver
8080_Diver
Flag of United States of America image

The Import Wizard is pretty self explanatory . . . thus the name "Wizard". ;-)
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?)
 
Avatar of Tony303
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.



ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial