CopyFromRecordset / TransferSpreadsheet VS. Automation / Query Ta

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am abit confused between the 3 methods. I'm assuming CopyFromRecordset and
TransferSpreadsheet are run from Access VB and Automation is run from Excel
VB?
 
I am abit confused between the 3 methods. I'm assuming CopyFromRecordset and
TransferSpreadsheet are run from Access VB and Automation is run from Excel
VB?
Click to expand...

Smarter people will probably correct me, but automation can be from
either side (Access pushing or Excel pulling)

CFR gives you a lot more control than TS, but can be a little more
difficult to work with. Search the groups, there have been some
excellent posts on how to implement both.

HTH,
Aunt Joy
 
Back
Top