MySQL Forums
Forum List  »  MySQL for Excel

How to upload Excel spreadsheet to MySQL database
Posted by: Sue Martin
Date: July 20, 2011 03:21PM

I am new to MySQL what is the correct way to be successful in uploading Excel 2007 data spreadsheet to MySQL database?

The database key is the first column of MySQL database and is to be auto incremented.

Should I build a column as a place holder in Excel to hold an incremented Id number per data row that will upload to MySQL?

I am working on a Windows 7 PC. The version of MySQL Workbench 5.2 CE and is Windows based. I also plan to use Java as the application language.

Please help. Thank you in advance.

Options: ReplyQuote

Written By
How to upload Excel spreadsheet to MySQL database
July 20, 2011 03:21PM

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.