importing multiple worksheets from excel to access

S

sarahphonics

Apologies for my lack of knowledge, Im a complete Access novice. I have
multiple copies of the same workbook in Excel, each workbook contains the
same table in the same range but has different values in the cells. I want to
automate an import in Access (transferspreadsheet???) that will automatically
import the data from each workbook into one access table and when this
process is repeated each month, the new data is just appended on to the end
of the table.

hope this makes sense

Sarah
 
K

Klatuu

The TransferSpreadsheet is the correct method to use for what you want. It
is also the normal behavior for it to append data to the destination table
when importing.
 

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

Top