cells that are outside the range of cells defined in

A

Arnie

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
 

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

cells that are outside the range 5
Import Excel to Access (used range only) 2
sort range 0
Sum At Top And Move Cells Down in VBA 3
Using user-defined functions in cells 1
Splitting cells in Excel 2007 2
Reference/define last cell 4
List/Combo Box Issues 2

Top