Transfer Excel sheet into Access by Macros

[Guest]

Helllo experts,

I need help. I want to ask if there is any possibility in Access to import
differents spreadsheets which are part of one file.
For example I have One spreadsheet that is structured as a template and
every user fills it. From this template the information is linked to another
two "data" spreadsheets. All these three spreadsheets are in the same Excel
file.
In the past the "data" sheet was only one and Access automatically decided
which of the two spreadsheets to import (the data or the template).
But know I created and second data sheet and wanted to create and second
Macro in Access which to import the information only from the "data2"
spreadsheet. The problem is that Access autmatically takes the information
from the first spreadsheet in the file. Is there some option to show Access
from which spreadsheet to take information?

Thanks in advance

 

[Ken Snell \(MVP\)]

Check out the Range argument for TransferSpreadsheet. It allows you to
specify such information.