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
rajeesh_rsn
0
Posting Whiz in Training
Recommended Answers
Jump to PostI'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.
All 3 Replies
blocblue
238
Posting Pro in Training
Featured Poster
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.
rajeesh_rsn
0
Posting Whiz in Training
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
buddylee17
216
Practically a Master Poster
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.