[thelist] simple method for uploading CSV files to MSSQL

Joel D Canfield joel at spinhead.com
Mon Aug 4 14:33:14 CDT 2003


> give em a file upload and then do a bulk insert.
> 
> for example:
> 
>     BULK INSERT databasename.dbo.tablename
>            FROM 'filepath'
>            WITH (FIRSTROW = 2
>               , BATCHSIZE = 200)
> 
> just look in your sql books for all the parameters and usage info.

Thinking out loud here: If I create a web interface so they can fire off
the SQL, their app could drop the data in a specified location, then
they perform the BULK INSERT using my web interface, then use the web
analysis tools to sort/filter/report.

I think that'll work.

tenks

spinhead


More information about the thelist mailing list