Alternative to transferspreadsheet

[phonic]

Hi, I want to import a very basic excel spreadsheet into access, and I'm interested to know if there is an alternative to doCmd.transferspreadsheet acimport? I know this method is simple, and I've used it many times, but is there an alternative.

If so, can someone send me the code, or give me any hints?

Thanks in advance for your help!

 

[Rabbie]

You can always have the excel spreadsheet as a linked table.

 

[phonic]

no, this isn't what I want. I have lots of spreadsheets to upload onto the database, linking isn't a viable option.

is there anything I can do with SQL?

 

[Rabbie]

You need to have the data in Access to run SQL on it so you need to choose between TransferSpreadsheet and linking the tables.

If the spreadsheets have the same format then you can copy the sheets dynamically to a standard name which you have already linked and then extract the data you want with queries.

 

[phonic]

aah that idea sounds interesting. do you have some code I can look at?