Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Red face Unanswered: Connection Between VBA excel and mysql

    Hello, I am a newbie to access Mysql using VBA for excel. How can I access a mysql 4.1 using VBA code ? Whar do i have to do? I just know that i have to install a ODBC driver but how can i do this ?? Please help-me.

  2. #2
    Join Date
    Mar 2005
    You should be able to use ADO to connect to the data directly. The hard part is the connection string use to access the database. Here is a link that will show some connection string examples:

    Here is another web site that may help you:

    Just remember that you will check the ado in the reference library in the vb editor to use the ado objects. Depending on what you are using the data for you may have to create a procedure to write data to the cells in the spreadsheet.

Posting Permissions

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