Member Avatar for asmikwen

Hello,

New here so hello.

I need to transfer an Excel file to Mysql with a large amount of data. I looked on a few forums but have not found much. Do you know how to do this? Is there an easy solution?

Thanks a lot.

  • 3 Contributors
  • 3 Replies
  • 106 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by bgkalbente

Recommended Answers

All 3 Replies

Member Avatar for mwasif

Save the Excel file as .csv and then use LOAD DATA INFILE to import data to MySQL.

Member Avatar for mwasif

Or you can use Navicat to directly import from Excel.

Member Avatar for bgkalbente

Alternatively, you can also use Datastage or Talend Open Studio to load the csv file into Mysql.

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.