BulkCopy

OpenRowSet

Posted on Updated on

Using OpenRowSet to read all data from an Excel worksheet into a global temp table.

INSERT INTO ##ABC
SELECT *
FROM
OPENROWSET(‘Microsoft.Jet.OLEDB.4.0‘,
Excel 8.0;Database=D:\EDI\SAMPLE_051311_1.xls‘, [Sheet1$])

Advertisements