You’re offline. This is a read only version of the page.
32
Hi,
I am new to Dynamics and am creating a new model app and want to import the data from an MS Access Database into my solution.
Access uses AutoNumber primary keys and associated foreign keys. Dynamics uses GUIDs.
What is your recommended process for improting data from Access to the new Dynamics solution?
I have 1->M tables (and of course M->1)
and also Many to many with intersecting tables in Access.
I was thinking of exporting from Access to Excel, adding a new column in excel named GUID, and from a separate excel file (for each table), doing an XLookup and inserting a new GUID for each, for example CustomerID. Then doing the same in related tables for foreign keys.
What do you think?
Any comments or suggested processes welcomed.
John
Hi Dr Dynamics,
You can migrate directly from Acess to Dataverse, ther was a pre-build connector,
You can follow this video :
learn.microsoft.com/.../migrate-access-to-dataverse
Or these steps if you want :
I tested it and it works :)
Please mark the answer as verified if that's helpful for you !
Best regards,
Share
Report
All responses (
Answers (
