MYSQL Excel Upload

[AntonyRayan]

Hi, can we import .xls file in mysql? or
how to upload .csv(Comma delimited) with multiple language using Load data?
how to save multiple languages in .csv(Comma delimited) ?

[cereal]

Hi,

you can convert the XLS to a CSV file and then import. Some forks of MySQL allow connection to outer data sources, through ODBC, so you can open an XLS or an MDB file and query it through the database interface, from there then you can copy it very fast.

See:

• https://mariadb.com/kb/en/mariadb/connect-table-types-odbc-table-type-accessing-tables-from-other-dbms/#retrieving-data-from-a-spreadsheet

About the multiple languages, could you show an example? Thank you.

[urtrivedi]

I used following excel plugin, its very convenient

https://www.mysql.com/why-mysql/windows/excel/