• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

Combine three databases into one in Excel


I've got three Excel spreadsheets (each from a different source) which I need to combine into a single spreadsheet. The data in the lists is from calls placed to members of an association sometime ago.

• List #1 contains 4097 unique member records (rows) each with nine columns (for demographic info, etc.). Some of the members included in the list were called once, some were called more than once and some not at all.

• List #2 contains 6680 records (each with seven columns) of the calls placed. Each call has a unique number (shown in gold in Fig. 1). The call records are tied to the member records by the name of the member (shown in yellow in Fig. 1).

Fig. 1• List #3 contains 3613 records, each with six fields (columns), documenting replies received following the calls.  The reply records do not include the member's name but do include the original call number from List #2 (shown in gold in Fig. 1).

What would be the best way to combine these three lists into a single spreadsheet so that each row represents a call and includes the member information and also the information for the reply to that call if it occurred?

1 Solution
In my opinion, for what you have described above the best way is to utilize MS Query to combine all 3 sources together (either using the excel sheets directly or directly from the sources if possible).

You can generate an MS Query from inside an excel sheet by going to Data > From Other Sources > From Microsoft Query.

There you get the option to query from Excel Sheets, MS Access Databases or your own defined data sources.

I hope this helps.

Good Luck!

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now