TransferSpreadsheet one specific sheet

[Teuntja123]

Hi all,

I want to import one specific sheet from an excel file and use the action TransferSpreadsheet.
The excel file (Named Report) has 4 sheets, but I want access to upload the second one called "Data".
What do I need to typ in the field name? C:/Documents/Report/????

Thanks in advance!

 

[pr2-eugin]

Teuntja123, Welcome to AWF

Use the name of the Sheet in place of the Range argument.. Something along the lines of.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12 , "TableName", "pathTo\Your\ExcelFile.xlsx", True, "theSheetNameHere"

 

[Teuntja123]

[FONT=&quot]Hi,

I don't know what you mean with the code..
Can't I change the link which you see in the attachment?
I Need the Sheet "Data" from the Inbound_Report


[/FONT]

 

[pr2-eugin]

After Has Field Names there is another Row called Range, in that type Data

 

[Teuntja123]

I feel embarrassed haha, so simple.

Many thanks!

 

[pr2-eugin]

No need to feel embarrassed, this is just a part of learning.

Glad you have it working. Good luck.