cells that are outside the range of cells defined in
 

hi guys and gals,
i posted this question in the Access forum but no answers i am trying to
read in several excel workbooks into Access which seems to be working
however,
one file i have tried to read in i get this

This table contains cells that are outside the range of cells defined in
this spreadsheet. (Error 3673)

i suspect i could define usable cells in the spreadsheet before it is read
in just in case there is a problem. the cells in question are A1:P7 (they do
not always have data in but sometimes they do ) but i don't know
how to do it.

to get the data into Access i use

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, , "Calls!K2:K2"

the previous code for "Calls!J2:J2" works fine as there is data in that cell
if there is no data in the UsedRange that is not a problem as i use Variant
to account for Nulls

hope i have explained this ok


many thanks in advance

Arnie