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
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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.