Articles

0

Like

The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)”

(https://idreesdotnet.blogspot.com/2018/12/the-ole-db-provider-microsoftaceoledb12.html)
I was trying to retrieve data from excel in T-SQL using the following statement:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\MyPath\MyFile.xlsx;;HDR=YES;IMEX=1', [Sheet1$])
Comments(0)

Post your comments

 

Other lins

.Net Techies
Other lins