Hi Group,
I am using TransferSpreadsheet to im****t excel data into access.
This works fine as long as I can supply a single data range (ie
"data$A2:AI50")
How do I supply a series of non-adjacent cell ranges?(eg
"data$A10:AI10,A13:AI13,A51:AI96")
I have tried the text above and it gives the errror
"The Microsoft jet database engine could not find the object
'data$A10:AI10,A13:AI13,A51:AI96'. Make sure the object exists and that
you
spell its name and the path name correctly".
Anyone know how to supply multiple cell references to the RANGE argument?
Any other ideas?
Thanks!
Meg
