Hi Pamela,

Have you tried to link the database to your workbook/spreadsheet with the template wizard. I think it'll let you do what you want, but I've not done it myself.

HTH,
Tom.

>I have several excel spreadsheets with numerous sheets. I want to take the sheet named 001 and copy everything to a table. I then want to go to the next spreadsheet and copy the info from sheet 001 to the same table as the previous. What is the best approach to accomplish this. I noticed that the IMPORT command names the table the same name as the spreadsheet. I want the data to go into a table I have designed.