Results 1 to 2 of 2

Thread: excel to mysql

  1. #1
    Join Date
    Feb 2005

    excel to mysql


    is there a free and simple way to import a xls file into a mysql db?

    the only thing i found was http://www.convert-in.com/xls2sql.htm which is 29 bucks. that´s not much and ok, but who likes to pay when there might be a simple solution?

    UPDATE: i found a way to do it without any additional software. export the xls as csv and prepare the table rows in phpmyadmin. then got to sql in phpmyadmin and use the "import text file" feature. et voilá

    Last edited by jogol; 02-06-2006 at 12:04 PM.

  2. #2
    Join Date
    Nov 2002
    Hermantown, MN
    As a side note there are a couple of converters out there that are free... I'll look up the link again if anyone else should need it.

Thread Information

Users Browsing this Thread

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

Posting Permissions

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

Recent Articles