Is it possible to import data directly into Excel 2007 via ODBC? I realize there have been discussion on this in the past, but I don't know if there is a clear resolution.
Even now, with the 64 bit ODBC driver installed, upon connecting, I get the MAS login screen. After providing login credentials, I get the 'unable to retrieve list of tables from datasource' error.
I do NOT want to use Microsoft query for this - ultimately, I would like to pull data in from MAS via ADODB connection in vba code behind.
Is there another method I might try to make this work properly.
The ODBC driver for any Sage 100 version is READ ONLY. You cannot pull data into MAS via ADODB. Now you may hunt around and find the ProvideX Read-Write ODBC driver but DO NOT use it as it will result in 100% data corruption 100% of the time. The ONLY way to bring data into MAS is with VI or BOI. Note that if you can write VBA code then you should be able to write code and use BOI to do what you want.
Thanks for the response BigLouie, but please note that I was asking how to pull data from MAS INTO Excel. (WITHOUT using Microsoft query).
OK now I see. Microsoft query seems to be an integral part of Excel and I don't see a way to pull data without using it.
So you can't pull data into excel using Data --> From Other Sources-->From Data Connection Wizard?
Only Data --> From Other Sources-->From Microsoft Query?
Unless something changed between 4.5 and 2013, it should work. I use it almost everyday.
Data - From Other Sources - From Microsoft Query
Edited - Sorry misread your post - I believe you do have to use Microsoft Query.
© 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blog List | Community Help