• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

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.
0
Hojoformo
Asked:
Hojoformo
1 Solution
 
8080_DiverCommented:
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?)
 
0
 
Tony303Commented:
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.



0
 
tbsgadiCommented:
Hi Hojoformo,

Have a look at the following:
http://msdn.microsoft.com/en-us/library/ms140052.aspx
Use the Flat file option

Good Luck!

Gary
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now