How can I import a text file into SQL Server

[dBjason]

SQL Server 7


I have 3 tab-delimited text files that I need to somehow suck into a new table in SQL Server. How can I do this?

Thanks,
Jason

 

[mrdenny]

You have several options. Ordered by Ease of use.

Import Wizzard
DTS
Bulk Insert
BCP

To use the Import Wizzard in Enterprise Manager, right click on the database select All Tasks, Import Data. Then follow the wizzard.

DTS (same idea put you do it manually).

For Bulk Insert and BCP check Books OnLine for the syntax.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[dBjason]

Thanks Denny

 

[JayKusch]

For Speed I would use Bulk Insert!

Thanks

J. Kusch