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) ?

Recommended Answers

All 2 Replies


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.


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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.