Excell to Access, transfer spreadsheet action

[tllouie]

I am transferring data into an existing SQL table through Access. I use the transfer spreadsheet action and I have multiple worksheets to import within a workbook. The transfer spreadsheet action works fine when I specify a range within a worksheet but it won't let me specify the worksheet alone. I don't know the number of rows within the worksheet so I can't specify that into the coded action everytime. Help!

 

[BillPower]

Hi tllouie,

I have an example of how to import single/multiple sheets by sheet or range name at

http://www.wpower.fsbusiness.co.uk/

. The file to look at is Import Multiple Excel Worksheets into Access .

If you take a look at the code behind the buttons, should point you in the right direction.

Bill

 

[janetlyn]

Bill, this is twice now I have found your site mentioned in a thread. However, I can get to the red sheet with the file, but when I click on the file to download it says there is nothing there. Has this been moved? Thanks, JL

 

[tllouie]

Bill,

Thanks for the info but I agree with Janet. I only can get to the red sheet with the one link. When I click on the link then I get an error message. Please post a more updated link. THANKS .

 

[mtwildtrout]

Bill,

When I try to get to your site I get an error message that Host was not found. Is there a problem with the site?