Need help combining large tables of data

scrapeape

New Member
Joined
Nov 16, 2009
Messages
1
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:eek:ffice:eek:ffice" /><o:p> </o:p>
The new program will only accept .csv import files. I can export those from the Access database.
<o:p> </o:p>
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:p> </o:p>
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:p> </o:p>
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:p> </o:p>
Are there any Excel macros out there that do something similar & could be modified to solve this issue?
<o:p> </o:p>
Thanks!
<o:p> </o:p>
~<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:eek:ffice:smarttags" /><st1:place w:st="on">Clark</st1:place>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,129,738
Messages
5,638,093
Members
417,005
Latest member
soso2727

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top