MSDN Support, feel free to contact P Parker, If you have any compliments or complaints to This can be beneficial to other community members reading this thread. I am not available with the IBM DB2 Database. So whatever I find based on my search, I am not able to make a test that It is working correctly or not.Īll the information I find is available on IBM Site.
So you can also raise this issue there and try to know about there suggestions. On my side, I find one work around that may work for you.ĭuring following this steps, you can record the macro. MSDN Support, feel free to contact Wouter, So at the end, When you get the data in Excel then you can view the generated macro to get the code. I had to make some minor changes in order to run the code. 'ThisWorkbook.Worksheets("Sheet5").Cells(1, 1).CopyFromRecordset rs Worksheets("Sheet2").Cells(1, iCols + 1).Value = rs.Fields(iCols).Name Dim conn As Object 'Variable for ADODB.Connection objectĬonn.ConnectionString = "Driver= UID=JPP PWD=Password Protocol=TCPIP Hostname=Host Name Port=10000 Database=DB_Name" Please find below the code that works for me. I have another question, just out of curiosity. #Lounge lizard ep 4 serial number code#Ĭurrently the above code works only with 1 database. Is it possible to get the record set for 2 database? Please note that the intent is to compare two tables hosted in 2 different database.
#Lounge lizard ep 4 serial number free#.#Lounge lizard ep 4 serial number code#.#Lounge lizard ep 4 serial number software#.#Lounge lizard ep 4 serial number install#.
0 kommentar(er)
