[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