Error while importing Excel

zachvaldez
zachvaldez used Ask the Experts™
on
I’m trying to import an excel file into Sql server using Sql server Import/Export tool however In the process I get error Microsoft. Ace. Olsen.12.0 provider is not registered on local machine
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
you probably need to download and install that drivers.

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-gb/download/details.aspx?id=13255

Microsoft Access Database Engine 2016 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=54920

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial