×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Import text file to sql DB

Import text file to sql DB

Import text file to sql DB

(OP)
Hello,

I need ideas how to import txt file to sql database.

Thanks,
Mona

RE: Import text file to sql DB

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 winky smile

Hope this helps,

Alex

----signature below----
I'm pushing an elephant up the stairs

My Crummy Web Page

RE: Import text file to sql DB

(OP)
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

RE: Import text file to sql DB

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

----signature below----
I'm pushing an elephant up the stairs

My Crummy Web Page

RE: Import text file to sql DB

You can also use the BULK INSERT command

Jack Vamvas

All the IT jobs in one place - http://www.ITjobfeed.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close