Import data from a single sheet on an Excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sorry, I made an error on my first post. I'm using the TransferSpreadsheet
command, not TransferData.

Jan Buckley
 
Back
Top