I’m in the process of transferring a database of client records from an old Access-based database program to a new database program.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>
The new program will only accept .csv import files. I can export those from the Access database.
<o> </o>
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).
<o> </o>
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.
<o> </o>
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”).
<o> </o>
Are there any Excel macros out there that do something similar & could be modified to solve this issue?
<o> </o>
Thanks!
<o> </o>
~<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on">Clark</st1lace>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>The new program will only accept .csv import files. I can export those from the Access database.
<o
> </o>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).
<o
> </o>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.
<o
> </o>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”).
<o
> </o>Are there any Excel macros out there that do something similar & could be modified to solve this issue?
<o
> </o>Thanks!
<o
> </o>~<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1lace w:st="on">Clark</st1lace>
