[buzzby]

any takers for this at all?

i would like to convert my excel spreadsheets to mysql. how do i go about doing this? i know of a tute on phpfreaks that converts mysql to excel. i want it the other way.

would be greatful for any hints or tutes that cover this.

let me stress that i want to convert my excel spreadsheets into mysql.

thanx for this

[liljoeyjordison]

hm, I can't think of a complete solution, but Excel can Save As a text file, and if you can find a way of putting a comma after every field you could use

Code:

LOAD DATA INFILE "datafile.txt" INTO TABLE tablename FEILDS TERMINATED BY ',' ;

That should do the trick

[Hammy]

You can either use PHP Excel Parser Pro (http://www.excelparser.com) if you need to keep fonts, date and cell formatting,
or if you want to process large Excel files you can use PHP Excel Converter (http://www.excelreader.com)
Both of them are PHP classes that you can use for your projects. The good thing about them is that you can download trial versions at the websites.

[NeverMind]

http://www.programmingtalk.com/showt...ighlight=excel

also liljoeyjordison's solution is good..

[End User]

Originally Posted by buzzby

any takers for this at all?

i would like to convert my excel spreadsheets to mysql. how do i go about doing this? i know of a tute on phpfreaks that converts mysql to excel. i want it the other way.

You can save them as CSV and do a mySQL import on them.

[creepycridler]

Yep, you can do all of the above or just save your file as a csv then import into your database using phpmyadmin.