www.webdeveloper.com
Results 1 to 2 of 2

Thread: excel to mysql

  1. #1
    Join Date
    Feb 2005
    Posts
    345

    excel to mysql

    hi,

    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á

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

  2. #2
    Join Date
    Nov 2002
    Location
    Hermantown, MN
    Posts
    1,777
    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