I’m in the process of migrating a database of client records from an old Access-based database program to a new database program.
The new program will only accept .csv import files. I can export those from the Access database.
Here’s my issue:
The Access database is broken up in such a way that client groups are assigned unique ID numbers. Those numbers are then tied to entries in various tables that contain all the contact info, account info, & personal information for every client group stored in the database, pooled together (so each entry in those tables is marked with the ID# of the client group it belongs to).
After exporting these tables of pooled data from Access, I need to use Excel to link all the different sets of data together using ID# assigned to each contact group.
I’m wondering if anyone can help me discover what is the easiest & most effective way of linking all of these sets of data together in Excel, using their common ID numbers (which are always found in a column titled “Client ID”).
Are there any Excel macros out there that do something similar & could be modified to solve this issue?
Thanks!
~Clark
Bookmarks