Import text file to sql DB

• Feb 7, 2008

• #2

AlexCuse

Programmer

Apr 13, 2006

5,416

US

well, if your database is SQL Server, you have bcp or DTS (SQL 2000) or SSIS (SQL 2005).

You probably should tell the mechanic what kind of car you have before asking them to order parts ;-)

Hope this helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

Upvote 0 Downvote

• Feb 7, 2008

• Thread starter
• #3

monaamit

Technical User

Feb 11, 2005

14

US

Thanks,

I was thinkng of doing it in SQL 2000. It is txt delimted file and I need to import and I need to import only 3 columns

 

Upvote 0 Downvote

• Feb 7, 2008

• #4

AlexCuse

Programmer

Apr 13, 2006

5,416

US

Because this is a whole lot to explain, I suggest you start here:

http://msdn2.microsoft.com/en-us/library/aa176533(SQL.80).aspx

But I also suggest that you save the resulting package, and really examine it using the DTS designer. Then post back if you have any questions about the different parts. This will help you to create a solid foundation and in the future let you take advantage of some of the more advanced capabilities of DTS.

Hope this helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

Upvote 0 Downvote

• Feb 8, 2008

• #5

JackVam

Programmer

Sep 21, 2007

60

GB

You can also use the BULK INSERT command

Jack Vamvas

All the IT jobs in one place -

http://www.ITjobfeed.com

 

Upvote 0 Downvote