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
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