Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Red face Unanswered: Create a connection to an informix DB using ODBC and parameters through Excel VBA

    For reasons out of my control I cannot use Microsoft Query and parameters for this, as would be desirable, so I wish to go through this route, but I'm not sure how.

    Using VBA, I want to establish a connection using ODBC to a database, and execute a SQL query passing two parameters that will be entered into cells A1 and B1 in the Excel worksheet by the users. I then require the dataset to be returned to the worksheet.

    Note: I'm using Microsoft Excel 2010 and Informix 3.82.


  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •