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

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
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Multiple Excel Spreadsheets 3
Flat File Database, Multiple Excel files into one Access Table 6
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Link Excel files to single Access table 5
Merge Excel spreadsheets to table 2
How do I automatically import multiple Excel spreadsheets? 1
Importing/linking any excel spreadsheet causes Access to crash 1
Link Excel files with external references... 1

Top