How to convert excel to MySQL?

Asked By betsy hupe 0 points N/A Posted on - 12/04/2012

 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

• Status: Open
• Question Views: 1126
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by Farrer Alan

Go To Solution

Best Answer

Best Answer

Answered By Farrer Alan 0 points N/A #159680

How to convert excel to MySQL?

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

About Farrer Alan

Questions
1

Answers
25

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 12/04/2012
• Question Category: Misc Software

Answered By dmsoft 0 points N/A #159681

How to convert excel to MySQL?

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

About dmsoft

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/05/2012
• Question Category: Misc Software