SmartConnect Excel add in error
Ted Lambert asked 10 years ago
I'm trying to get SmarConnect's Excel add-in working for uploading a map.
I can see the Web Service, and that has been put in the web service field… should I use the root, or a path further down the tree?
However, I'm getting the following error:
"Error Reading from sheet 'Visa', please check the sheet name and Data"
The sheet is present, and I've tried Visa$, and other varations.
The map works fine run against the actual SmartConnect program.
Is there any more information in regard to getting debugging info, or anything that can help pinpoint what isn't working?
Info:
Smartconnect 20.11.11.61
Dynamics GP 2010
Excel 2010
I can see the Web Service, and that has been put in the web service field… should I use the root, or a path further down the tree?
However, I'm getting the following error:
"Error Reading from sheet 'Visa', please check the sheet name and Data"
The sheet is present, and I've tried Visa$, and other varations.
The map works fine run against the actual SmartConnect program.
Is there any more information in regard to getting debugging info, or anything that can help pinpoint what isn't working?
Info:
Smartconnect 20.11.11.61
Dynamics GP 2010
Excel 2010
Answers
Best Answer
DHolmes answered 10 years ago
DHolmes answered 10 years ago
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
The problem is explained in this article with key points being the redistributable file to download, and the install tip . To summarize, first you must download the accessDatabaseEngine file at http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 and run this from the command line using the ‘/passive’ flag to allow 64-bit office to run the excel addin.
Thanks
Dusty
The problem is explained in this article with key points being the redistributable file to download, and the install tip . To summarize, first you must download the accessDatabaseEngine file at http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 and run this from the command line using the ‘/passive’ flag to allow 64-bit office to run the excel addin.
Thanks
Dusty
Did you find a fix for this? We're getting the same thing.
I suspect this is because of Excel Office being the 64-bit version.
Add-ins work fine on my local (32-bit) version of Office, but not at all on the 64-bit version on my VM.
eOne – can we PLEASE get a difinitive answer on this one?
Thanks,
Ed