| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Posting Recordset to SQl Server
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:=ConnectStr ing, Destination:=Range(DataTarget), Sql:=mySQL) .Refresh BackgroundQuery:=False End With Please Help Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| Error when opening recordset of SQL Server via ADO | Excel Programming | |||
| the owner of posting should be able to delete the posting | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
| Type recordset/recordset? | Excel Programming | |||
Linear Mode
