Member of the Month

hi_vis360
November, 2024

Online

Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!

How to refresh an Excel table filled with data from a MYSQL Database !

profile picture
joris.blanc
Posts: 914 - Karma: 6,584
So I want to refresh my Excel table every so often from a MYSQL database that gets new rows every so often.

I have been able to import the Database into my Excel table, but then I cannot figure out a way to update that table with new data added to the MYSQL Database.

- To be able to connect to my MYSQL Database I use the MYSQL software MYSQL for Excel - Version 1.2.1

Any one have an idea how or if it is something that can be done ?
Apr 28 2014 9:56AM
42 1
profile picture
theBearJew
Posts: 10951 - Karma: 15,633
Have you tried downloading adobe reader?
Apr 28 2014 9:57AM
5 0
profile picture
joris.blanc
Posts: 914 - Karma: 6,584
theBearJewHave you tried downloading adobe reader?


And do what with the Adobe Reader ?
Can't find anything anywhere even thought they say that there is an auto refresh function in version 1.2 !!
Apr 28 2014 10:10AM
0 0
profile picture
I_Am_Mod
Posts: 13214 - Karma: 3,753
have you tried turning it off and on again ?
Apr 28 2014 10:12AM
5 0
profile picture
SFB
Posts: 8895 - Karma: 26,353
have you tried downloading the latest version of adobe reader and then turning off and on?
Apr 28 2014 10:13AM
4 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
do you have a right click - refresh option?
Apr 28 2014 10:15AM
0 0
profile picture
I_Am_Mod
Posts: 13214 - Karma: 3,753
its probably breadcrumbs in your disctray
Apr 28 2014 10:19AM
3 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
http://www.w3resource.com/mysql/exporting-and-importing-data-between-mysql-and-microsoft-excel.php
Apr 28 2014 10:20AM
0 0
profile picture
CaptainObvious.
Posts: 5712 - Karma: 20,638
system32 needs a driver update. Uninstall and reinstall.
Apr 28 2014 10:21AM
4 0
profile picture
ged.bend
Posts: 156 - Karma: 1,483
sounds like the steering column, take it in.
Apr 28 2014 10:25AM
5 0
profile picture
theBearJew
Posts: 10951 - Karma: 15,633
I_Am_Modits probably breadcrumbs in your disctray


OP stop using your disk drive as a bagel holder.
Apr 28 2014 12:06PM
1 0
profile picture
joris.blanc
Posts: 914 - Karma: 6,584
CaptainDickbuttsystem32 needs a driver update. Uninstall and reinstall.


Thanks, almost fixed my issue ;)
Apr 28 2014 12:25PM
1 0
profile picture
.Capn.
Posts: 1454 - Karma: 152
MySQL -> CSV or other .txt -> Excel

Klugey but would work?
Apr 28 2014 12:57PM
1 0
profile picture
Hammyslapwagon
Posts: 1261 - Karma: 1,411
Just a simple refresh? Press f5
Apr 28 2014 1:04PM
1 0
profile picture
joris.blanc
Posts: 914 - Karma: 6,584
.Capn.MySQL -> CSV or other .txt -> Excel

Klugey but would work?


Yes it would work, but you would have to manually do everything every time.

I was trying to use MYSQL for Excel to automatically retrieve values, but you can only import the data. You have to use something like ODBC to link to the Database to the table and then you can refresh the data !!!
Apr 28 2014 1:13PM
1 0
profile picture
CaptainObvious.
Posts: 5712 - Karma: 20,638
joris.blancYes it would work, but you would have to manually do everything every time.

I was trying to use MYSQL for Excel to automatically retrieve values, but you can only import the data. You have to use something like ODBC to link to the Database to the table and then you can refresh the data !!!


Yeah, unfortunately Excel doesn't have any live update link to applications outside of itself without 3rd party help or an API.

Whatever your solution, it will always have to be manual.

If you've got any kind of coding knowledge, it would not be hard to write a quick application that queries your database and transposes the data into an excel file.
Apr 28 2014 1:32PM
1 0
profile picture
chicken
Posts: 6843 - Karma: 2,121
excel? what the fuck do you need that shit for?
Apr 29 2014 2:59AM
1 0
profile picture
joris.blanc
Posts: 914 - Karma: 6,584
chickenexcel? what the fuck do you need that shit for?


To analyse data my friend !
Apr 29 2014 7:37AM
1 0
profile picture
Parrish
Posts: 8695 - Karma: 1,009
joris.blancTo analyse data my friend !


Wouldn't it be better to use actual database software like access?
Apr 29 2014 7:44AM
1 0
profile picture
joris.blanc
Posts: 914 - Karma: 6,584
.Andrew.Wouldn't it be better to use actual database software like access?


Maybe, but in Excel with Pivot Tables it's really easy to make charts that you can customize without to much work and it is pretty easy to view the results.
Apr 29 2014 7:57AM
1 0
profile picture
chicken
Posts: 6843 - Karma: 2,121
well props for using open source software. but I don't know the answer to your question because I don't use excel for anything. The only time I ever use spreadsheets is when I am collaborating with someone and they insist on using the damn things.
Apr 29 2014 12:43PM
1 0
All times are Eastern (-5)