Xls2mysql converts data from XLS to MySQL.
The software is loaded with several key features, such as using the first line of the excel file to create sql columns, using the filename to create tables, and using each following row (from 2 to N) to create inserts. However, it is important to note that the software does not actually perform the sql, and instead requires you to copy and paste the results to your favorite sql admin interface.
Although the software has various benefits, there are still some limitations, such as the inability to detect field types (numeric, text, longtext, unique).
To use the xls2mysql application, you will need to download the package 'xls2mysql.zip' and unzip it to a web folder that has PHP. Then, you can run the xls2mysql.php page within your browser and upload your files or test from the sample xls files from the file list tab. Additionally, if you choose to upload files, make sure to check that php has read/write rights on the xls folder.
Lastly, xls2Mysql uses several open-source tools, such as Super-Simple DHTML Tabs by Joshua Olson, Sliding doors of css by Douglas Bowman, and Spreadsheet_Excel_Reader. Overall, xls2mysql is a helpful tool for individuals looking to quickly and easily convert XLS data to MySQL.
Version 1.0: N/A