Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Transact-SQL
1

Yet again some compatibility issue with the this nightmare of a system. I've got 32 bit office and 64 bit SSMS (2008 sql R2).

As soon as I use a later version of excel (.xlsx) instead of (.xls) it fails.

Trying to run a package that imports from Excel, but get message oledb 12.0 not available when I create the connection to the file and try picking the sheet.

What do I need to install to fix this thing? I wonder if it is these, which were listed in pinal dave's blog:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Why are the files called AccessDatabase, when it causes issues in Excel as well?

Thanks

Andrew

2

Is there any way you could convert files to csv

3

I could I suppose. Will have a look at it, thanks

4

it will save you a lot of these headaches of installing providers etc. better yet use tab delimited.

1 Like