Import Export wizard Error

Question

Hi All,

I am new to this area , i am trying to import data from a .XLSX file to a table and Iam facing the following error after the selection,

Data source: microsoft excel, browse to the file path "e.Final.xlsx"

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

please guide the way to get this to work,

Thanks in Advance...

Answer 1

Found a simple solution covert the file to .xls and every thing goes fine.

Answer 2

Hi Jack,

Thanks for sharing your idea.

Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.