I want to export data from a table Access in Excel using vb6.0

[diaExcel]

I want to export data from a table Access using vb6.0 and ADO, can I do that?
and how?

thank you.

 

[ArielZusya]

Unfortunately I've only been coding in VBA since more recent versions. That
said, the way I do that in VBA now may have existed in version 6. So...
check out the help on DoCmd.TransferSpreadsheet which has the ability to
import or export. As for the ADO portion... again... not that familiar with
ADO programming. There is a note about linking rather than exporting using
ADO in the help for TransferSpreadsheet method in VBA 6.5. That note reads
as follows:

You can also use ActiveX Data Objects (ADO) to create a link by using the
ActiveConnection property for the Recordset object.

Anyhow... I hope all of that helps. Let me know if there is more I can do
to be of assistance.

 

[RoyVidar]

I want to export data from a table Access using vb6.0 and ADO, can I
do that? and how?

thank you.

You can probably use/reverse some of the techniques discussed or linked
to here (watch for linebreak in link)
http://groups.google.com/group/micr...1a6fe4c1637/5d5a8bf359cf0d66#5d5a8bf359cf0d66

But also, look into the CopyFromRecordset method of the Excel Range
object, which can take both ADO or DAO recordsets.