Member Avatar for rajeesh_rsn

hi, i had a mysql table and my friend make the database in excel file. Now I need to import my excel file into mysql table. Anyone help me how to do this ...

Thanks in Advance

  • 3 Contributors
  • 3 Replies
  • 83 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for blocblue

I'd suggest saving the excel file as a CSV, then write a quick PHP script to read the file and compose SQL queries.

A quick google search should yield some results. I'm personally not aware of any means for going direct from Excel to MySQL.

R.

Member Avatar for rajeesh_rsn

I'd suggest saving the excel file as a CSV, then write a quick PHP script to read the file and compose SQL queries.

A quick google search should yield some results. I'm personally not aware of any means for going direct from Excel to MySQL.

R.

thanks

Member Avatar for buddylee17

Also, if you have phpmyadmin, you can just upload the csv instead of writing a script.

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.