26.5 Export Excel Data into MySQL

Data from a Microsoft Excel spreadsheet can be exported to a new MySQL database table by using the Export Excel Data to New Table option. Exporting data looks like so:

Figure 26.9 Exporting Excel data to MySQL

Exporting Excel data to MySQL

Advanced Export options

Several advanced options enables you to tweak the exported data. The advanced options dialog looks like so:

Figure 26.10 Exporting Excel data to MySQL (Advanced options)

Exporting Excel data to MySQL (Advanced options)