Importing from Access to new Dynamics Solution

(0) Share

Report

Posted on by GiJohn

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

All responses (1)

Answers (0)

Suggested answer

Mohamed GRAIB 2,500 Super User 2025 Season 1 on at

Like (1)

Report

RE: Importing from Access to new Dynamics Solution

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 :

support.microsoft.com/.../get-started-migrate-access-data-to-dataverse-013c8bab-7737-46ca-ad2e-892bbf26287d

I tested it and it works :)

Please mark the answer as verified if that's helpful for you !

Best regards,