How to Import an Excel data to SQL Table

Question

I want to import all my excel data to my web sql database. is that possible?

That is, I'm trying to make a web site for school database and i have many school contact info as excel sheet. I need to import all that data to sql data base

nacho · Accepted Answer · 2017-05-26 06:58:03Z

1

You can convert the excel to a csv file and then use the mysqlimport statement.

answered May 26, 2017 at 6:58

nacho

5,3772 gold badges28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dwhitz · Accepted Answer · 2017-05-26 08:14:43Z

0

You can try something like this:

edited May 26, 2017 at 8:14

Dwhitz

1,2688 gold badges28 silver badges40 bronze badges

answered May 26, 2017 at 7:11

Evgtar

11 bronze badge

Collectives™ on Stack Overflow

How to Import an Excel data to SQL Table

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related