filepath error when trying to transfer spreadsheet into access

[virencm]

Hi

I have created a macro that will transfer an excel file data into an access table.
the problem i am facing is that i want to specify the worksheet i want to transfer.
in the macro window the file path i specify is C:\My Documents\[consume.xls]sheet 2 and it gives me an error. can i not specify the worksheet here? or do i have to do it via VBA?

Thanks
viren

 

[DCrake]

What error is it throwing up?I suspect it may be to do with the [] characters in the file name.

 

[boblarson]

There should be a Range argument in the TransferSpreadsheet macro action. It doesn't go in the file name argument.

 

[virencm]

Thanks for your help guys. It works.