merging spreadsheets on Access?

J

John Vinson

Can you merge existing Excell Spreadsheets with Access?
Click to expand...

Please post a more detailed question.

Access is a relational database; Excel is a spreadsheet. They are
DIFFERENT; Access isn't a "larger version" of Excel.

However, you can link Excel spreadsheets to Access, import them as
Access Tables (which look like spreadsheets but aren't), merge them,
reexport them to Excel, and generate reports and forms from them.
 
R

Roxie Aho

Not sure what you mean by "merge."

You can import (File>Get External Date>Import)as a new
Access table.

You can add data from an Excel spreadsheet to an existing
table (Import) if the column headings are the same and you
don't violate any primary keys.

You can add data to an existing table by importing to a
new table, then running an append query on the new table
if you have more columns in the spreadsheet than you do in
Access.

You can link (File>Get External Date>Link) to an Excel
spreadsheet so changes you make in Access are made in
Excel and the changes made in Excel are made in Access.

Roxie Aho
 
Top