Advice on exporting from RM10 to Access or Excel including notes

RootsMagic
1

Advice on exporting from RM10 to Access or Excel including notes (preferably Access).

Been looking at programs online that can export the basic data, but none seem to be able to handle the notes.

Anybody got any ideas or links to online resources.

2

There have been recent discussions here about connecting Excel and POWERBI to a RM database using ODBC and old and recent posts and chats about likewise connecting Access on sqlitetoolsforrootsmagic.com

1 Like
3

Once you have the ODBC connector installed and connection configured for you RM Database (need a configuration for each RM database) – you can get by without knowing any SQL/Sqlite. You would need some basic understanding of Power Query and Database Structure. If you have intermediate Power Query (and M Code knowledge) you can do a lot more with knowing Sqlite. If you combine intermediate SQlite & Excel Power Query(built into Excel Data Connection Query) your potential is only limited by your skills.

1 Like