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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Import tools for Dynamics GP

(0) ShareShare
ReportReport
Posted on by 217

Are there any free tools for importing into GP

*This post is locked for comments

I have the same question (0)
  • steveendow Profile Picture
    2,281 on at

    Hi John,

    The only free import option I'm aware of is the GP Table Import feature.  I would generally only recommend it for very simple imports, such as for master records that are very simple and don't affect multiple tables.

    support.microsoft.com/.../856667

    dynamicsgpblogster.blogspot.com/.../often-overlooked-yet-powerful-table.html

    If you want to try table import, definitely thoroughly test it on the Fabrikam database or a test database first.

    You could potentially also use direct SQL inserts or SSIS, but again, I generally wouldn't recommend those for anything other than simple master records or very specific imports that don't affect multiple tables.

  • Suggested answer
    sandipdjadhav Profile Picture
    18,319 on at

    In Master, you don't  just import customer ID or Name you import address and other information too. So it get affect another tables too. I am not big fan of table import. I think Microsoft allow 90days free trial of Integration Manager.

    Here is type of Import for Dynamics GP sandipdjadhav.blogspot.com/.../types-of-integration-method-with.html . You can try Macro it is free..

    Thanks

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    In terms of free integration tools, I would recommend the Macro.It is a totally free, generic and easy to use especially with excel. It records your mouse clicks and keyboard entries. The only disadvantage of it is the slow performance.

    On the other hand, GP Excel Paste is one of the essential products that deserves some of your time to look at.

    GP Excel Paste

  • L Vail Profile Picture
    65,271 on at

    hi John,

    What are trying to import? For instance, an import tool for Fixed Assets is part of the module.

    Kind regards,

    Leslie

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans