Importing Excel

[raymond3090]

Hi,

I have a bunch of Excel spreadsheets that I want to import into Access. The data in Excel is all on a single worksheet, but I don't want it all to go into the same table in Access. I know where I want everything to go, but I have no idea how to write the code to import and split based on some sort of searching method, and then store in separate tables.

Also, can I store into a table that has not yet been created?

I'm wondering if anybody has a short piece of code used to import an Excel sheet that I can use to give me an idea as to how it is done. I think that then, I should be able to procede on my own!

If anybody has any advice I'd be grateful to hear it!

Regards,
Ray

 

[AlanS]

You can use either the TransferSpreadsheet method or the TransferSpreadsheet action to import spreadsheet contents into a table, and they both provide a Range argument that lets you limit the import to a particular range of the spreadsheet.

I'm not sure if you can specify a non-existent table and have the action/method create it for you on the fly - try it and see.