Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Cannot export from sage 300 2014 to excel results in MDAC error.

Posted By Philip Nel over 8 years ago

i have not seen this in years any problem with MDAC. when printing report to preview and then export no issue but trying to do any import/Export out of Sage say MDAC need to be installed and activated. Any idea where to start looking.

Database MS SQL 2012

Operating System Win 10 Pro

Sage 300 2014 PU3

0 Jay Converse Acumen over 8 years ago

What Office version?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Philip Nel over 8 years ago in reply to Jay Converse Acumen

Apologies MS office 2013
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to Philip Nel

32 or 64 bit?
I've seen this happen when IT install 64 bit Office, it complains about the 32 bit Access db engine and so they uninstall it - then Sage 300 export/import fails. You may need to reinstall the Access db engine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 P.Bribosia over 6 years ago

Did you ever fix the issue ? Was reinstalling the Access db engine the solution ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Cannot export from sage 300 2014 to excel results in MDAC error.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING