Using Excel for MySQL database import

[inspireme]

Hello All & Happy new Year!

Intro:
I have a rather sneaky little problem on my hands where I have member data (3000 members! yikes!) that I've already exported successfully as a .csv from my contact database in Excel & formated it to import into MySQL using phpMyadmin.

The problem is I don't know Excel that well & I've only figured out a very labor intensive way to surround values with quotation marks & parentheses. Here's the steps I took so far:

1) Save that file as a csv, and open it in Excel.

2) Import my other data into Excel and cut and paste data into the appropriate columns.

Here's where I'm stuck!
3) Format data to look exactly like the original data by surround all values with quotation marks (")

4) I also have to get the parentheses on the first and last field, and the semi-colon at the end.

Lastly I have to delete the first two rows (the headings and sample data) and save the file as a comma delimited csv. whew!

Please some good soul - tell me a better way...preferrably step-by-step!

Please read on to Part 2 to see actual data...

Thanks in advance for your help!

Best.
-Jenn

[inspireme]

Anybody out there?


I did mean what I posted: quotation marks (') and parentheses () and yes
I do need to have commas in between all values, (outside parentheses of course!)

BTW, I posted the sample data from excel to help you understand what I need: http://www.inspiremedia.info/go/coming/xls_forum/
remember it's only a few row I have 3000 more after that. (the data is a bit sqeexed together at the end).

Please let me know what you think..