docmd transferspreadsheet

[mcnewsxp]

how can i specify a particular worksheet using the docmd
transferspreadsheet?

thanks,
mcnewsxp

 

[mcnewsxp]

thanks much.
meant for this to go to Access.general but there isn't one.

 

[Guest]

No problem. I use Access a lot and I had just used the TransferSpreadsheet command recently where I needed to specify the worksheet. Good timing...