How to link multiple excel spreadsheets to a single access db?

  • Thread starter Thread starter Nikki W
  • Start date Start date
N

Nikki W

For the past 3 years a new spreadsheet has been started each year to organise
the data of students receiving financial assistance. Now that I took over
the job I want to combine them into one database using Access, but keeping
the master data in Excel. The format of the spreadsheets have stayed the same
for the past 3 years.

There are students who have received assistance more than once, so their
info appears on more than one of the spreadsheets.

My question:
Is it possible to link all 3 spreadsheets to a single Access db, combining
the duplicate data? Or will I have to do that manually?

Thanks!
Nikki
 
AFAIK, you can link multiple spreadsheets in a single database - but not in
a single *table*. you'd have to link each spreadsheet individually, and
combine the tables in a UNION query.

hth
 
Back
Top