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
Bookmarks