MySQL and excel

  • Thread starter Thread starter bawar
  • Start date Start date
B

bawar

Hey, I can say I belong to the newbies in this subject. I own my own
website with mySQL-databases, but now I have to show one table of
those mySQL-databases in an excel worksheet. It is the intention that
the user opens the excel-file trough the browser, so I hope there does
not have to be installed anything on the clients machine... It would
be very nice if someone could tell me step by step how I can do this.
It is very important for me, coz I have a good chance to get a job if
I can get this to work. So thx very much in advance!

Bart
 
There are ODBC drivers to connect to mySQL database on their website. You
can import the table into excel with an ODBC connection and then the excel
file can be downloaded or viewed with the excel viewer available from
Microsoft. There are also third party products that convert excel to other
forms for publishing on a website like Excel Everywhere.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update MySQL database using Excel VBA 1
ADO connect mysql 1
How can I import data from a mysql database into excel 3
Best way to export from Excel to MySQL? 1
Problem mysql import in powerPivot for Excel 2010 1
Excel 2003, Microsoft Query - reference to subquery alias 1
Access for MySQL data reports only 5

Back
Top