importing multiple worksheets from excel to access

  • Thread starter Thread starter sarahphonics
  • Start date Start date
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
 
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.
 
Back
Top