Laurel Eppstein
Last Activity: Jan 25 '11, 09:16 PM
Joined: Jan 24 '11
Location:
-
Unfortunately, the Rest of the World is moving on, including my coworkers and associates. Therefore the need for up-converters, which I fear have ruined Office 2003. -
It seems as though it's an Access problem. When I imported my entire database into Access 2010, the same thing occurred: could see named ranges of .xlsm files, but not .xls files. For various backward-compatibility issues, I do not choose to develop in 2010. ARGHH!Leave a comment:
-
Another piece of info: this works seamlessly in Office 2010, if I save the file first as a .xlsm type, and then specify the spreadsheet type as 12. However, if I try to do the import in Access 2010 of spreadsheet type 8 or 9, with the older version of the Excel spreadsheet, it can't find the named range!Leave a comment:
-
Here's the spreadsheet
Thanks for staying with me on this. BTW, I'm using Office 2003, but with Office 2007 converters loaded.Leave a comment:
-
1. Range assignment is a string, identical to the table to which it will ultimately be appending in Access. An example is "tblFacilit y". The transferspreads heet method creates a temporary table of the same name, but with the 'tmp' prefix.
2. The first row of each named range has field names
3. I would upload the spreadsheet except that I see no way to do so: the allowed extensions are picture-types or docs or txt.Leave a comment:
-
ADezii, that code is no different than what I had posted. I get the same error running it as I did with mine. Yet when I have the spreadsheet open, it runs just fine. THAT is the problem!
Thanks for trying,
LaurelLeave a comment:
-
How to import data from named ranges in Excel 2003 into Access?
I have no hair left with this issue! I'm simply trying to import data from named ranges in Excel 2003, into tables of the same name in Access 2003. I have found that unless I have the spreadsheet from which I want to import, OPEN, the named ranges cannot be found. I can't even see them trying to manually import the data, unless the spreadsheet is open!
I don't want the spreadsheet open because that causes an instance of Excel to remain...
No activity results to display
Leave a comment: