1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I have an excel spread sheet with a lot of information on it and i would like to export it to MySql and so i can post it on the net and make it searchable. Can anyone one help of piont me in the right direction. Thank you
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Rep Power
    Export your spreadsheet as a text file. (I tend to use tab-delimited, since sometimes data may have quotes, apostrophes, or commas.) View the text file with a text editor first to make sure it exported the way you expected. Then, use the LOADDATAINFILE command to load your data into the MySQL table. (Make sure that your end-of-line characters are either unix or that you correct for it when you use the LOADDATAINFILE command.)

Similar Threads

  1. import excel into mysql
    By imran7841 in forum PHP Development
    Replies: 3
    Last Post: July 12th, 2004, 10:15 PM
  2. PHP MySQL and Excel Import
    By s3computers in forum PHP Development
    Replies: 3
    Last Post: December 15th, 2003, 08:07 AM
  3. How to convert an EXEL sheet into MySQL DB
    By Ole Nygaard in forum PHP Development
    Replies: 1
    Last Post: August 27th, 2003, 02:24 PM
  4. mysql acting as MS Excel, will it be?
    By TheJuan in forum PHP Development
    Replies: 2
    Last Post: August 26th, 2003, 03:35 PM
  5. how to hide gridlines in an excel sheet
    By arshi in forum Apache Development
    Replies: 0
    Last Post: May 28th, 2003, 08:25 AM

IMN logo majestic logo threadwatch logo seochat tools logo