Converting Your Excel Worksheet into a Working MySQL Database - Conversion requirements and restrictions (Page 2 of 4 ) We need to determine what is needed, as well as the limitations, in order to convert an Excel workbook into a working MySQL database. Take note of the following before doing a conversion: Not all MySQL versions or phpmyadmin interfaces are the same. Some may differ according to the versions released. So this tutorial will try its best to illustrate two versions: the offline version using XAMPP/phpmyadmin, and the online version using a real MySQL database provided by a web hosting company.
Depending on your type of hosting, some hosting companies will not allow direct import of an external file to the MySQL database, so there are alternative steps to this illustrated below. For example, there are some instances where the website has been hosted under shared conditions (like those of free web hosting), importing of files to the MySQL environment is not being supported. In this case, you can either upgrade your hosting account or try other steps.
Before exporting any Excel-related worksheets to MySQL, first you need to create a database to handle it.
You can only export one worksheet at a time to the MySQL database that you have created. Exporting is fast and easy provided they are in compatible formats and within a reasonable file size.
The Excel worksheet should be clean (free of fancy formatting such as images, colors, wrap text and fancy fonts) before exporting it to MySQL. If the first column in your Excel spreadsheet has the field name “Movie ratings,” the first field name should occupy the first column and first row, so it will be in cell A1, in the Excel worksheet.
Next: Exact steps in the XAMPP phpmyadmin panel >>
More Database Articles
More By Codex-M |
