Importing a range from a spreadsheet

G

Guest

I am trying to import several spreadsheets into an Access database. I have
the following command for each spreadsheet. How would I insert a range from
the spreadsheet instead of the entire sheet.

DoCmd.TransferSpreadsheet acImport, 8, "ImportAccessName",
"fileNameBeingImported", False"

Thanks
 
G

Guest

Look in VBA Help for the TransferSpreadsheet method. There is a Range
argument. You can specify a specific sheet or a range of cells within a
sheet.
 
J

Jeff Boyce

Disregard the "you cant do this" message. It is SPAM (or worse), and has
been showing up all over the newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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