importing data/outputing data mysql

I'm fairly new to MySQL and have been presented with a couple of problems. I have a .csv file with names addresses and such which looks like so:

"Joe Smith"
"1234 Main St. Sometown, NY 11111"
"1968"

What I need to do is:
1. Import these values into a table called clients.

2. Sort these values by street address(street name) so I can print them out.

Any help would be appreciated...

Are you running Windows? Do you have Microsoft Access? You can import the data into Access from a CSV file, then export it to MySQL via ODBC (no text commands, totally visual way of doing it).

Let me know if you want help setting up ODBC for Win32.

All you want to do is print out the info, right? Don't you want to query MySQL via PHP/PERL?

Best,

nao

I could either do this on windows or linux, as I have both running at my desk. A little background on this project. One of the managers in my office gave me a printed list of names, addresses, and a few other details. Asked me if I could figure out a way to reorder them so that they are ordered by street address. So I scanned them in ran them through an OCR app that I have which can output to csv file. Then figured I could import them into a simple table to print them out in the order I want. I don't plan on reusing the information, other than to output it in the format requested.

If you have Microsoft Access, all you have to do is open a new database in access (use the wizard if you're not sure how to do this) and right click on the database window, selecting 'Import'. Then just choose the file format (CSV) and import!

Then you'll have an Access DB that you can visually sort and print. You can get really creative with 'Reports' etc., MS Access has a great helps section on how to do that.

best,

nao