get info from excel into DB

[kimanh]

Hi everyone,

I have a list of addresses in an excel spreadsheet. Is it possible in PHP to get all the data from the excel spreadsheet into a database? I would like to create a website to manipulate (add, delete, edit) the data. However, I do not want to manually enter all the data in the spreadsheet again. Thanks!

Kim

[schmalenegger]

hi,

i don't know if my solution fits to your problem:

with excel you can save a file as a csv (i think it means comma seperated values) -file.
To import the values from this csv-file to your database use this mysql query:

LOAD DATA INFILE "data.txt" INTO TABLE db.table;

within this command you can tell the database how the values are seperated and if you want to insert the first line in data.txt.

You can find a good description here:
http://www.mysql.com/doc/en/LOAD_DATA.html