importing data from excel to access

[davyre]

Hi, I'm trying to importing data (more like copying all the data) from an excel file to Access using VBA. I tried to use

DoCmd.TransferSpreadsheet

but it shows error saying Could not find installable ISAM.
What can I do with that? Is there any simple method to copy the whole excel file into a recordset (not a table), so that I can use the recordset with different excel files(by closing the recordset - I assume it will automatically remove the recordset and recreate new recordset whenever I import a new excel file), rather than using a table and erase the whole content each time I want to import from another excel? Thanks!

 

[Golom]

You can directly open a recordset based on an Excel file using ADO. Check out this Excel Connection String.

This is hardly "simple", however. Perhaps you can post the full DoCmd.TransferSpreadsheet that you were attempting to use and we may be able to suggest how to fix it.