Importing into mySQL

[webpenner]

Okay, I've created a mysql database and created an online administrative section to update/add/delete and maintain the information in my database via php. I now want to upload a spreadsheet in .txt format, I've read the directions in the mySQL manual and was wondering if there is a utility or an easier way to go about it. Am I stuck using the directions is mySQL or does some one have an easier way?

[pjdv]

I'm not sure that this is the easiest method, but you can log into MySql Manager (from the Control Panel), enter phpMyAdmin, select the table you want to insert the text file into, and then click on the link marked "Insert textfiles into table."

I've saved excel spreadsheets as .csv files and uploaded them. Not sure if .txt will work. Good luck.

[richmedium]

Upload your file to your account and run a "load data infile" query.

See this: http://www.mysql.com/doc/L/O/LOAD_DATA.html

[webpenner]

Thanks for your help...I used the utility built into myphpadmin and it worked like a charm.

webpenner