Member Avatar for 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) ?

Edited by AntonyRayan
  • 3 Contributors
  • 2 Replies
  • 297 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for 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:

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, networking, learning, and sharing knowledge.