Results 1 to 5 of 5

Thread: Excel File Into MySQL Database

  1. #1
    Registered Mike's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    2,755

    Excel File Into MySQL Database

    Hi all,

    I have a big excel file that needs to be put into a MySQL database. Does anyone know a script or program that will be able to do this? It would be nice if it was free as well, seeing as I'll only be using it once

    Cheers,
    Mike
    Don't you just love free internet games ?

  2. #2
    Senior Member agua's Avatar
    Join Date
    Sep 2005
    Location
    Pottsville, NSW
    Posts
    531
    I've used this csv importer with good results in the past to import my excel files to mysql... but you have to save them as a csv.

    I found it fairly easy, and I ain't no php/mysql guru
    I Do Website Design - but I am here to learn all about publishing

  3. #3
    Gimme Fries with that!
    Join Date
    Aug 2004
    Posts
    1,469
    i just saved mine as a csv and imported it using phpadmin. My excel file had 15,000 records, you may have to use telnet to do it depending on the file size.

  4. #4
    Site Contributor KLB's Avatar
    Join Date
    Feb 2006
    Location
    Saco Maine
    Posts
    1,181
    I like to use Microsoft Access for this task. I will link to the excel spreadsheet or CSV file via Access and then create an append query to push that data into the MySQL table that Access is also linked to via ODBC.
    Ken Barbalace - EnvironmentalChemistry.com (Environmental Careers, Blog)
    InternetSAR.org: Volunteers Assisting Search and Rescue via the Internet
    My Firefox Theme Classic Compact: Based onFirefox's classic theme but uses much less window space

  5. #5
    Registered Mike's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    2,755
    I tried the CSV importer script, but that didn't seem to install correctly. It turns out that the phpmyadmin method was the easiest and quickest. I was trying to upload the file through the wrong upload form before

    Thanks guys!
    Don't you just love free internet games ?

Similar Threads

  1. How do I write and retrieve strings from a text file using PHP?
    By KLB in forum Website Programming & Databases
    Replies: 7
    Last Post: 06-04-2008, 10:27 PM
  2. A Resource Directory of File Extensions
    By ! search-engines- in forum General Chat
    Replies: 0
    Last Post: 01-20-2006, 11:31 PM
  3. Clear my misunderstanding: 1 MySQL database for many programs?
    By iKwak in forum Website Programming & Databases
    Replies: 4
    Last Post: 08-21-2005, 10:40 AM
  4. Database File Manager
    By rapain in forum Website Programming & Databases
    Replies: 4
    Last Post: 10-23-2003, 06:09 AM
  5. Database Driven Websites
    By star in forum Website Programming & Databases
    Replies: 6
    Last Post: 10-21-2003, 03:51 PM

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
  •