Posting Recordset to SQl Server

C

Candyman

HI,
I normally query a db2 Database into Excel for reporting. Now I have to run
the SQL code to extract from DB2 and then post to SQL Server.

How do I do that?

my code to retrieve data is:
With ActiveSheet.QueryTables.Add(Connection:=ConnectString,
Destination:=Range(DataTarget), Sql:=mySQL)
.Refresh BackgroundQuery:=False
End With

Please Help
Thanks
 

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

Setting the connection string to a QueryTable.refresh 1
Pause code for data return 2
Query to DB2 2
Connection to MySQL using VBA 1
SQL ODBC Connection 0
getting data from web 0
problem with VBA web query 1
issue with ODBC connection to DB2 4

Top