Excel2mysql 1.0

Excel2mysql 1.0 offers you a sophisticated and powerful tool which can convert Microsoft Excel spreadsheets(xls) into mySQL database. These tool can produce SQL dump file anda also can connect to local mySQL server and export the record. User can use these excel2mysql with sequentially button to follow step - by step of conversion. No need specific installation.

1. Run the Excel 2 mySQL software.
2. On the first run. software will ask for the unlocked code.
3. Copy paste the code from the software.
4. Check your email to get the unlocked code.
5. Prepare the Excel file you want to convert. Note :
   • currently these software only convert the first sheet. So make sure that the data already in the first sheet.
   • The first row will become the name of the database field. And telling the amount of column.So make sure that you already naming the all column.
6. After the Excel file ready, on main form application. Click Convert.
7. Select/Open the Excel file.
8. Application will automatically run the converting process.
9. On success, you will see result on the result box. If you want to save the result to file just click on Save 2 file button.
10. The next step is to insert/run the sql to your local mySQL server.
11. First complete your mySQL configuration(server, port, user, password, database), and ensure that the user has the create & insert previllege on the database.
12. Click the insert 2 sql button.
13. On success, the application will create new table with the result record. you can check with your mySQL Client sofware.

Requirements: win2000

WareSeeker Editor