mysql / excel q
- Started
- Last post
- 5 Responses
- ********
problem: my wife knows excel, i want her to be able to populate a long list of data, and then i want to import said data into a mySql database.
any pointers? gracias in advance.
- cosmo0
you need help with a script?
If you are using php then there is a class to handle all data.
http://sourceforge.net/projects/…
or saving the excel file as a csv format using excel, and then read the file using php.
- akoni0
you can have excel export a txt file also with the data for mysql, and if you have something like phpMyAdmin, it will easily import it
- justjeff0
Both can use CSVs. For mysql -> Excel, dump it with your favorite programming language, write to CSV. Then use LOAD DATA to get back into MySQL.
- ********0
okay, so she can type it all up in .xls format, then i can export that as a .csv and import it into mySql via phpmyadmin? sweet, I'll try it.
thanks
- ********0
hold everything this isn't working, I don't think i'm structuring the .csv data correctly. Can someone give me some pointers? gracias.