db2

  1. ScottDarth

    VBA ODBC Activity is crashing Excel

    I'm trying to write some code that will iterate through rows in an Excel spreadsheet (I'm using Excel 365 Version 1908). For each row, it'll check to see if that row's "unique identifier" exists in a database. It *happens* to be a DB2 database, but it could be any ODBC source. I'm trying to...
  2. K

    Mapping data using formulas.

    I have 2 sets of data in 4 columns. In DB1 is the main database. DB2 is the information extracted from a vendor application. DB1-SystemName DB1-ipaddress DB2-SystemName DB2-ipaddress What I am trying to achieve using excel formulas is to map the data elements to DB1 elements. The...
  3. J

    Problem connecting to DB2 server

    Hello. I normally use the Table Import Wizard in PowerPivot to get new data. I normally use an OLEDB/ODBC connection to connect to my DB2 database. But when I try to connect to the database through the IBM DB2 connection wizard, I'm getting this error message: "failed to connect to the server...
    • jk-vtti
    • Thread
    • db2 server table import tizard
    • Replies: 0
    • Forum: Power Tools
  4. D

    Correct Syntax - VBA to Run SQL in DB2

    I'm using an Excel macro to run several SQL queries. Some are Teradata queries, and one query is a DB2 query. To synch up all the queries to return comparable data, I’m using a column in a worksheet to define parameters for the SQL where statements. This lets me control the inputs in one...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top