Insert into [SQLServerTable] Select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=e:\weblink.xlsx;',
'SELECT * FROM [Sheet1$]'
Uma variação a considerar se a opção anterior não funcionar:
SELECT A.* FROM
OPENROWSET (
'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=\\San\rep\test.xlsx;HDR=YES;IMEX=1',
'SELECT * FROM [Sheet1$]'
) as A
Mensagens de erro possíveis e work-arounds:
ResponderEliminarhttp://www.sqlservercentral.com/blogs/sqlandme/2013/04/15/sql-server-import-data-from-excel-using-t-sql/