tranferspreadsheet filename question (multiple worksheets within the workbook for import)

[StevieRayB]

Hi all;
I have an Excel workbook that has 2 worksheets named "decision" and "quality". I need to load these 2 worksheets to Access into 2 seperate tables named (you guessed it) "decision" and "quality".

I have a form that builds the path and filename portion of the macro to execute the "transferspreadsheet" command.

I need to know exactly how the "filename" that includes the path is supposed to look to load the "decision" worksheet into the "decision" access table and the "quality" worksheet into the "quality" access table .

The path and filename is:
g:\excelfiles\accesstransfer\daily-transfer.xls

Thank you.
<!-- / message -->

 

[Joe4]

Welcome to the Board!

I find when importing multiple worksheets from the same Excel file into Access, it works best if you name the ranges you want to import on the Excel file (from Excel, highlight the range on the first sheet, Insert -> Name -> Define -> give it a name, then repeat for the other sheet).

On the TransferSpreadsheet action in Access, you can see the last argument is for the name of your range. Populate accordingly, and you should be good to go!

 

[StevieRayB]

So I put the name of the individual worksheet in the "Range" field and I'm good to go?

 

[Joe4]

No, you enter in the name of the range you created in Excel (go back and read my post again on how to name your range in Excel).

Also note that in Access, you can press F1 to get more detailed help on the arguments for the Macro actions.

 

[StevieRayB]

Ok, I see what you mean. I'll give it a go on Monday. Thanks for your time!