TransferSpreadsheet range syntax

[Guest]

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

 

[Pat Hartman]

Have you tried - "Sheet3!A1:B1260"

 

[Guest]

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

 

[Guest]

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.

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.