Merging several linked tables into one table

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

Guest

Dear All,

I'm an Access newb using 97.

I have an excel spreadsheet which staff members fill in daily to complete there statistics for there days work.

It has the named range data where is has the various column titles then the data below it.

Each staff member uses this same spreadsheet which is called after there name.

In Access I have added these to tables as linked tables picking up the named range "data".

I want to be able to merge all of these 8 linked tables into one table for me to do a query and report on.

Can anyone help please?
 
I want to be able to merge all of these 8 linked tables into one table for me to do a query and report on.

Can anyone help please?
Click to expand...

A UNION query will help here. You need to create the query in the SQL
window but it's not all that hard - see the online help for UNION. It
would be something like

SELECT "Adam" AS Employee, [thisfield], [thatfield], [otherfield]
FROM [Adam]
UNION ALL
SELECT "Eve" AS Employee, [thisfield], [thatfield], [otherfield]
FROM [Eve]
UNION ALL
<etc throught the eight linked tables>

Either use this Query directly as the source of your report, or base
an Append query on it to migrate the data into a permanent table.
 
Back
Top