How to upload Excel spreadsheet to MySQL database
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.
Subject
Views
Written By
Posted
How to upload Excel spreadsheet to MySQL database
3968
July 20, 2011 03:21PM
1744
July 20, 2011 03:29PM
1603
July 20, 2011 03:41PM
1469
August 01, 2011 08:34AM
1308
August 01, 2011 12:05PM
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.