News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Can data stored in Ext...

Microsoft Dynamics GP (Archived)

Can data stored in Extender tables be exported to tables in a third party database?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

We are trying to limit the number of times the same information is manually entered for our company. We have Extender installed with GP 2010 to store additional information on each Item Maintenance card. It is working great for data imports into GP from an Excel spreadsheet created from a dBASE IV system for thousands of items. However, we would also like to export that same data from GP to the third party Accellos' vship database tables to avoid manually entering it again. Is this possible in Extender?

Any help is greatly appreciated.

Patti Parks

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Can data stored in Extender tables be exported to tables in a third party database?

Yes - in that the Extender tables are SQL tables - so you can export the data, say with a sql view or something. Or by creating triggers. Hwever while extender is a great product the data is stored in a complex way (it needs to be done this way to allow extender to be so flexible). Anoher way you could export the data is to use a smartlist if you install the extender extensions. Export to XL and import to the other system.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans