Please need to help for this problem that I have. I need to read a sheet of excel from sql. I want to read this data what contains data and store in a temporal table. But right now I am having problems with read Excel because it shows me a error from sql. What I need for reading it
Error:
Not registered the OLE DB provider "Microsoft.ACE.OLEDB.12.0"
I hope you can help me with it problem, please.
I have executed it. Maybe I am missing something.
SELECT * --INTO TB_EXAMPLE FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; Database=C:\Microsoft\Test.xls; HDR=YES; IMEX=1', 'SELECT * FROM [Plan1$]') GO
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire