Import Error "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

When you trying to use the Microix import feature to import from Excel, you may receive the following error. Use the link below to download the missing driver from Microsoft download site.

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

Options Operating System MS Office OLDEDB
Drivers Required
1 32 Bit 32 Bit Download 32bit ACE.OLEDB Driver
2 64 Bit 64 Bit Download 64bit ACE.OLEDB Driver
3 64 Bit32 BitMicroix Runs in 64 Bit OS Mode on 64 BIT Operating System, So 32 Bit Office will not work if they have 64 BIT OS. Customer should install 64 Bit Office in order for Excel import to work.



It seems you have 32 bit Office and 64 Bit OS and Microsoft does not provide OLEDB Drivers for this setup combination. You need to either have 32 OS with 32 Bit Office or 64 Bit OS with 64 Bit Office in order for import to work or you can import using CSV Format. Save the excel file as “CSV” and Microix will import without the need for Office. This is our preferred method.


For the special patch Navigate to Microix Share\AutoUpdates\Patch and run "wfmpatch64_Import" on the machine that has 64 Bit OS and 32 Bit MS Office. (Applicable for version 2013.42.4 and above)