How to convert excel to MySQL?

Asked By 0 points N/A Posted on -
qa-featured

 Hi,

I have created data tables on Excel. I want to convert  them to mysql and load them. Please tell me how can I convert excel to mysql and load them? Thanks

SHARE
Best Answer by Farrer Alan
Best Answer
Best Answer
Answered By 0 points N/A #159680

How to convert excel to MySQL?

qa-featured

Hi Betsy Hupe,

You want to convert excel data table to MySQL and load them. There are several ways for converting. But the standard way is export data from MS Excel spreadsheet as TXT or CSV, then create empty MySQL table with the appropriate structure and “LOADDATA:MySQL command.

It is very easy to use. For the accurate migration of complex MS Excel spreadsheets Excel –to-MySQL provides enough capabilities.

Thank you for your question.

Farrer Alan

Answered By 0 points N/A #159681

How to convert excel to MySQL?

qa-featured

Hello,
Try the tool from https://dbconvert.com/ Embedded autoselector feature defines data ranges automatically. Then it loads selected data directly to mysql.

Related Questions