MySQL Forums
Forum List  »  MySQL for Excel

Connect MySQL to an Excel Spreadsheet
Posted by: M Von Heinrich
Date: September 07, 2012 06:07PM

I have an Excel spreadsheet with muiltple workbooks in it used by Multiple users. It constantly goes corrupt, even as a shared workbook.

It's a fairly complicated spreadsheet with a lot of formulas and fields.

I followed a couple tutorials on connecting it to MySQL using ODBC and the MySQL server, but it fails every time.

Do I need to create a MySQL database that matches all the fields on the spreadsheet?

I'm trying to avoid having to re-create the Excel spreadsheet in another program. I just want to use it as a front end. Any thoughts on how I might accomplish this?

Thank you in advance.

Options: ReplyQuote

Written By
Connect MySQL to an Excel Spreadsheet
September 07, 2012 06:07PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.