Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import a picture into a pre defined range of cells - excel 2003 | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming |