Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2008
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have managed to get my mysql table to appear in excel but can't for the life of me figure out how (or even if its possible) to update the data constantly as the data in the mysql table is updated.

    Any help would be appreciated.

    Ed

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Click a cell in the external data range.
    Activate the Data tab of the Rbbon.
    In the Connections group, click the arrow next to Refresh.
    Select Connection Properties from the dropdown menu.
    Avtivate the Usage tab.
    Tick the "Refresh every" check box.
    Enter the number of minutes between each refresh operation.

    Warning: setting the number of minutes to 1 may put a considerable burden on the MySQL server.

  3. #3
    New Lounger
    Join Date
    Jun 2008
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you very much, I couldn't find that anywhere.

Posting Permissions

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