SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Level 8 Chinese guy Archbob's Avatar
    Join Date
    Sep 2001
    Location
    Somewhere in this vast universe
    Posts
    3,741
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Importing excel data into mysql

    Hi,
    Can anyone tell me how to import excel data into mysql. I tried uploading it, but it won't work.

    I have a column called "email" in excel that I want to grab and put into a mailing list in mysql. Is there an easy way to do this?

  2. #2
    SitePoint Guru
    Join Date
    May 2004
    Location
    santa rosa, ca
    Posts
    969
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You might try a google search for something like "excel to mysql converter". There are many programs out there to make this easy.
    nondenominational, noncommercial, nonprofit,
    listener-supported, 24-hour, Christian ministry:
    Listen Live Online

  3. #3
    Level 8 Chinese guy Archbob's Avatar
    Join Date
    Sep 2001
    Location
    Somewhere in this vast universe
    Posts
    3,741
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there anyway to get parse the data with php?

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    i know how to make excel files with php, but not the other way around. your best bet for loading excel data in to mysql is to save the file as CSV and use LOAD DATA IN FILE. and before you ask how to do that, serch for LOAD DATA CSV MYSQL on the forum and you will see lots of examples of how to do it.


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
  •