Software for Excel to MySQL Import
We tested many products for importing Excel into MySQL. This chart shows 4 established products..Product | Excel2MySQL |
SpectralCore |
Oracle MySQL for Excel |
NaviCat for MySQL |
Auto calculate column width |
|
|
||
Optimize field types |
|
|||
Stand-alone exe |
|
|||
International unicode character support |
|
|
||
Load multiple sheets |
|
|
||
Command Line Interface Conversion |
|
|
||
Excellent Documentation |
|
|
||
Accurate |
|
|||
Unmerge merged cells | ||||
Detect and add new coloumns during append to existing table | ||||
Works with all versions of Excel | ||||
Support for SSL | ||||
Quick, Easy and Intuitive |
|
|
||
Time to Load 18884 rows 31 cols |
17 secs |
156 secs |
82 secs |
10 secs |
Price | $300 |
Free |
$100+ |