+ Reply to Thread
Results 1 to 4 of 4

Excel/MySQL: Refreshable database connection?

  1. #1
    Registered User
    Join Date
    09-14-2018
    Location
    Oregon, United States
    MS-Off Ver
    2016
    Posts
    2

    Excel/MySQL: Refreshable database connection?

    So, I have 4 different MySQL databases with 4 different invoicing layouts for products/services I sell on Wordpress sites.

    I want a spreadsheet with a tab for each different invoicing system that is "refreshable". I am assuming that I would need to use ODBC connectors, but can anybody point me in the direction of a walkthrough for how to accomplish this?

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Excel/MySQL: Refreshable database connection?

    So, yes, you can use External Data Queries to create the link, via ODBC, and refresh them that way... some people use VBA etc but if you don't need to, don't bother.

    https://dev.mysql.com/doc/connector-...wordexcel.html

    Clearly you will need the appropriate MySQL ODBC Driver installed, if not already.

    Personally I find the "helpful" query UI a little cumbersome (read MS Access-esque), and if you prefer to code SQL directly you can use the SQL button in the editor to type in directly.
    Once you've configured a query, and returned data, you can also amend the SQL via the Properties --> Connection Properties --> Definition pop-up window.

  3. #3
    Registered User
    Join Date
    09-14-2018
    Location
    Oregon, United States
    MS-Off Ver
    2016
    Posts
    2

    Re: Excel/MySQL: Refreshable database connection?

    I'm also a little bit lost on exactly how this data is saved. So, I want to have this .xls saved on a network share so that I can edit it from multiple computers. Does the connection data have to be stored on the machine running Excel? Or can the connection data live on the NAS too?

  4. #4
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Excel/MySQL: Refreshable database connection?

    If you wish to refresh the data from source then, IME, the MySQL ODBC Driver would need to be installed on the various clients.

    I would caveat the above by saying that there will be others more knowledgeable than me who can likely advise better.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-13-2017, 04:58 AM
  2. Refreshable Data Connection from Web to Excel TABLE
    By MishaJames1972 in forum Excel General
    Replies: 9
    Last Post: 03-10-2017, 05:59 PM
  3. MySQL Query from Existing Database Connection
    By manofcheese in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2015, 04:33 PM
  4. Connection between Excel and MySql Workbench
    By joseto_caviedes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-12-2014, 09:08 AM
  5. Excel as a database, VBA, MySQL
    By gdubf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2009, 01:39 AM
  6. Using Excel for MySQL database import
    By inspireme in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 06:59 PM
  7. [SOLVED] connection to internet mysql-database
    By masterphilch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1