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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
New Error using CopyFromRecordset 1
Format text when export data from Access to Excel 2
Automating Excel to run an auto open macro in the sheet. 4
TransferSpreadsheet and parameter query help? 2
Programmatic way to remove Excel from Memory 3
Error Exporting Access Query Results to Excel 1
IP Address 4

Back
Top