What's the easiest way to export a table from either MS-Excel or OpenOffice calc and import it into a mysql database, where:
- The table will be imported as a table in Mysql
- The headers of the table will be the fields of the MySQL database
- There will be some smart analysis what data type is inside the cells, e.g. a Text field, an integer or a floating point value.