Xls2mysql converts data from XLS to MySQL.
The xls2mysql project is a useful software application that enables the user to easily convert data from XLS to MySQL. With xls2mysql, you are provided with a simple and user-friendly DHTML interface that allows you to easily upload and display the files available for conversion.
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.
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.
What's New
Version 1.0: N/A