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.

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

Or you can use Navicat to directly import from Excel.

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.