Link Excel into Access

[Scadadude]

I have several spreadsheets that are identical except for the data in the cells. Does anyone know how I can link the same sheet from all the spreadsheets into one table in access without manually coying the data into the table one at a time?

Thanks in advance

Scadadude

[CreganTur]

You can link your spreadsheets to Access and then use an Append query to pull the data from the linked table into an exisitng Access table.