CODEWITHSUNDEEP
mysqlexcel
Shihab EK
Shihab EK

Reputation: 70

How to Import an Excel data to SQL Table

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

Upvotes: 0

Views: 77

Answers (2)

Evgtar
Evgtar

Reputation: 1

You can try something like this:enter image description here

Upvotes: 0

nacho
nacho

Reputation: 5397

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

Upvotes: 1

Related Questions