How to output recordset data to sheet

T

Terence

Hi,

I am writing a macro which uses ADO to connect to DB2
AS/400 database and return the recordset data to the
worksheet.
But I found that when I use ADO with QueryTable, there is
some problem such as only part of data is returned to the
worksheet,..etc.
Therefore, rather that using QueryTable, is there any
other method with can return recordset data field by field
into seperate worksheet columns?
Thanks a lot.

Terence
 

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

Get Picture from Access Database 0
QueryTables, some basic questions 5
ADO - Access to Excel 5
Help to get data from excel 2003 worksheet into Visual Basic 6 1
return ADO record set from Add-In? 1
Reset QueryTable error on empty text file 1
Can't create recordset to populate userform combobox 3
Macro to Combine Data from Multiple Sheets with Cell References 4

Top