TransferSpreadsheet to import local named range?

D

David Powell

Is it possible to import to an Access table a named range that is
*local* to a sheet within an Excel workbook? The user interface
(File|Get External Data|Import) seems to assume that either a global
named range or a worksheet will be specified - not both.
My attempt with DoCmd.TransferSpreadsheet to specify
<sheetname>!<namedrange> resulted in an error message with the
exclamation mark (!) replaced by a dollar sign ($).
I'm trying Automation (with other problems there at present .. to be a
separate post). But am I missing something?
Excel/Access 2000, but will have 2002 presently.
David
 

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

Similar Threads

Using TransferSpreadsheet to import from Excel to Access with variable file names 1
TransferSpreadsheet problem 0
Import Excel named range into Access 2
how to paste a copied Excel range into a table in Access via VBA?transferspreadsheet inadequate 2
TransferSpreadSheet Question 1
Import Excel 2010 table into Access 2010 - not listed as range 0
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel ranges - clarify 20

Top