I have a named range in an Excel Spreadsheet called "ImportArea". Is there a way to import a named range in Access (2000). I can do each individually but I get errors when trying to get it all at once.
='Fee Matrix'!$A$5:$C$5,'Fee Matrix'!$A$8:$F$27,'Fee Matrix'!$A$31:$F$59,'Fee Matrix'!$A$62:$F$77,'Fee Matrix'!$A$81:$F$90,'Fee Matrix'!$A$94:$F$96,'Fee Matrix'!$A$101:$F$106
='Fee Matrix'!$A$5:$C$5,'Fee Matrix'!$A$8:$F$27,'Fee Matrix'!$A$31:$F$59,'Fee Matrix'!$A$62:$F$77,'Fee Matrix'!$A$81:$F$90,'Fee Matrix'!$A$94:$F$96,'Fee Matrix'!$A$101:$F$106