1.Want to know if its possible to import mutiple excel files into Access 97 database using VBA codes. The excel files are used only for one time use.

2. Is it possible to create a parameter to select the the excel file i need to import to a temporary Access table.

I tried TransferSpreadsheet command but it works for import of only one excel sheet.

A sample code for import of mutiple excel sheet would be appreciated ASAP.

swati