Using Excel for MySQL database import
 

Hello All & Happy new Year!

Intro:
I have a rather sneaky little problem on my hands where I have member
data 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! :confused:
3) Format data to look exactly like the original data [color="Red"] 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! :eek:

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

Thanks in advance for your help!

Best.
-Jenn


--
inspireme
------------------------------------------------------------------------
inspireme's Profile: http://www.excelforum.com/member.php...o&userid=28209
View this thread: http://www.excelforum.com/showthread...hreadid=498862

Using Excel for MySQL database import
 

Anybody out there?:eek:


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..


--
inspireme
------------------------------------------------------------------------
inspireme's Profile: http://www.excelforum.com/member.php...o&userid=28209
View this thread: http://www.excelforum.com/showthread...hreadid=498862