Importing a range from a spreadsheet

[Funkyfido]

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

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[Klatuu]

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.

 

[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