I get "subscript out of range". What's that?

[Guest]

I am setting up a database from scratch and importing from an excel
spreadsheet. I have set up tables in access and want to import named ranges
into specific tables. The first hitch is that I don't have a way in the
import wizard to specify the named ranges, even though that option is given -
the named ranges are not itemized in the box, and secondly, when I try to
import the worksheet, I get a "subscript out of range" error message.

Also, is there another way to import named ranges? I have read in my
manuals and online and in training materials that named ranges can be
imported rather than whole worksheets but there are no specific instructions
that I've seen that outline how to do that. Can anyone direct me in that
regard?

 

[Guest]

Look in VBA Help for TransferSpreadsheet. One argument is the Range
argument. You can specify which sheet and which rows and columns within the
sheet.

 

[Guest]

Where is that? I'm pretty new to this.

Look in VBA Help for TransferSpreadsheet. One argument is the Range
argument. You can specify which sheet and which rows and columns within the
sheet.