Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using FSO can we import CSV file...Help Please 1

Status
Not open for further replies.

shawn876

Programmer
Feb 19, 2004
17
US
Hi:
I have a CSV file which I need to import into a SQL Server table. But I created a form on an asp page. I needed to know if I can use FSO to import this csv file into the sql server table. If yes How?
Thanks
 
Yes, but this is tedious work when there are many fields. You should consider using DTS (part of MS SQL) for this job.

ttmug.gif
 
Look in the MS SQL Server Enterprise manager under "Data Transformation Services". Go to "Local Packages" and create a new package (right click in right window) Add a server object (drag/drop) and a Text File (Source) and a Transform Data Task. You can completely visualy design the process (even with "On success" and "On failure" workflow).


ttmug.gif
 
excellent post foxbox!

___________________________________________________________________

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top