VB Script to upload .CSV to SQL Server 1

[jsteff]

I have a .CSV file that I want to read and INSERT into a single SQL Server table.

Do you have an example of the VBScript code that would do that for me?????

Thanks.

 

[mrmovie]

an ADO thingee can read a csv file into a record set...i think

 

[wcburton]

If you are running SQL Server 2000 (or later) you can use DTS in SQL Server to do the job. If it is just a straight import you can just use a copy task in the transformation. If you need to do any data manipulation you can use an ActiveX transform task. You can have it loop for multiple import files and set it up through SQL Agent to perform the task on a schedule. Or you can use DTSRUNUI to create a command line and use any other scheculing method.