web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SmartConnect
Microsoft Dynamics GP (Archived)

SmartConnect

(0) ShareShare
ReportReport
Posted on by Romryan

Dear all,

I am new in smart connect. Am doing GL with AA. I would like to have a template and the way the mapping is done up to AA level. I will highly appreciate.

Again Excel 2013 data source  is not working and the connection is not successful. Its bringing a connection problem. But excel 97-2003 is working. CSV is still working and I can preview. I have installed excel 2013 addon but the connection aint going through.

Kindly help.

RomRyan

*This post is locked for comments

I have the same question (0)
  • Angel Nuñez Profile Picture
    Angel Nuñez on at

    Can you provide more details about the error if any or the exact behavior?

  • Romryan Profile Picture
    Romryan on at

    Angel,

    ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. This is showing when I use Excel 2013 as the datasource but csv and excel 97-2003 datasource are not throwing the error when I try to Validate or Preview.

    Also I need an excel template for GL-AA integration and guidance on mapping.

    RomRyan.

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at

    I assume Excel 2013 is installed on the same machine that the SmartConnect client is?

    (We don't have excel 2013 installed on ours, still on Excel 2010)

    As for a template, I thought eOne had one...the usage of it will depend on how your AA is configured.

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at

    I had the same error a few weeks ago and I ended up installing the 32 bit Office 2007 drivers. See this post from eOne Solutions for the complete explanation.

    www.eonesolutions.com/.../kba-01228-w0f9w7

  • Manikandan Profile Picture
    Manikandan 2,845 on at

    GP will support only 32 bit ODBC connection but it will support 64 bit excel. Since the e connect is processing through OLE DB, Make sure the OLEDB and MS office are in 32 bit architecture.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans