Import data from a single sheet on an Excel workbook

J

Jan Buckley

I'm using the TransferData command in an ACCESS macro to import an Excel
spreadsheet as a table, and I'm having trouble telling it which sheet to
select. Can you give me the syntax? Thanks.
 
J

Jan Buckley

Sorry, I made an error on my first post. I'm using the TransferSpreadsheet
command, not TransferData.

Jan Buckley
 
Top