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
I need ideas how to import txt file to sql database.
Thanks,
Mona
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
Import text file to sql DB
|
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.
RE: Import text file to sql DB
You probably should tell the mechanic what kind of car you have before asking them to order parts
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
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
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
Jack Vamvas
All the IT jobs in one place - http://www.ITjobfeed.com