+ Reply to Thread
Results 1 to 2 of 2

Using Excel for MySQL database import

  1. #1
    Registered User
    Join Date
    10-19-2005
    Posts
    12

    Arrow There an easier way 2 essentially make text strings?

    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
    Last edited by inspireme; 01-06-2006 at 07:01 PM.

  2. #2
    Registered User
    Join Date
    10-19-2005
    Posts
    12

    Talking Part 2: There an easier way 2 essentially make text strings?

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1