Using Excel for MySQL database import

  • Thread starter Thread starter inspireme
  • Start date Start date
I

inspireme

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 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
 
Anybody out there?:eek:


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

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

Please let me know what you think.
 
Back
Top