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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top