TransferSpreadsheet range syntax

M

Mark CHP IMD

I would like to use DoCmd.TransferSpreadsheet acImport to access 2 columns of
data in a spreadsheet. I’m having trouble with the range. I can import one
column/field, but I can’t get the syntax for two fields. One field,
"Sheet3!A1:A1260†works great. Anyone know how to do this? Is it possible?
Thanks,
Mark
 
M

Mark CHP IMD

Thanks for the response. I found the solution was in creating a separate
sheet with the purpose of formatting the data columns in such a way as to not
include extraneous data.
M
 
B

boblarson

Thanks for the response. I found the solution was in creating a separate
sheet with the purpose of formatting the data columns in such a way as to not
include extraneous data.
Click to expand...

Actually, that isn't true. The SOLUTION is what Pat suggested. What you
did is a WORKAROUND. There is an important difference.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Top