Combining multiple linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables linked to Excel spreadsheets. Each spreadsheet has the
same data fields:
Organization
Date
Issue
Status

I want each project leader to fill out their spreadsheet and then I want to
combine all the fields from each spreadsheet into one report using MS Access,
grouped by Organization.

How do I create a query that will accomplish this?

Thanks,
Mark
 
I believe you would create a union query to do this.

The HELP file will assist you in building a union query.
 
Mark

Having one table per project (or project leader, or ...) is quite suitable
.... if you're using a spreadsheet!

You and Access will both end up working way too hard unless you re-think
your data structure and make it more like what Access is designed for, i.e.,
relational.

Keep your links to the spreadsheets, but create a "combined" table. Create
one query for each link that loads the data from your linked spreadsheets
into the combined projects table, making any necessary conversions. These
queries will also add the projectID, etc., so you'll have a way to query the
combined data by project. A 'date loaded' field might be nice, too.

You can "automate" the loading process, either by writing a procedure to
sequentially call the "load" queries, or you can use a macro to do the same.

Good luck!

Jeff Boyce
<Access MVP>
 
Back
Top