BULK INSERT

[maneland]

Can I insert an external file using BULK INSERT? For example

BULK INSERT Table
FROM '

http://www.site.com/file.csv'

WITH (FIELDTERMINATOR = ',')

Thanks

 

[mrdenny]

You would need to download the file to a local drive or network share first, then you can bulk insert the file.

Bulk Insert doesn't understand a URL.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com