Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    32

    excel (csv) to mysql

    hello,

    i have some excel files that i need to upload to mysql tables. i did a search to look for tools. the ones i found are listed below. i'd like to know if anyone has used any of them and if so, what you thought.

    free
    http://www.hotscripts.com/Detailed/17912.html

    not free
    http://www.convert-in.com/xls2sql.htm

    http://www.mysqlstudio.com/product.php3

    thanks
    indera

  2. #2
    Join Date
    Aug 2001
    Location
    United kingdom
    Posts
    1,003
    You can do this manually. If your host has phpMyAdmin, you'll be able to import a database in CSV format. To get the CSV file, just generate it in Excel.

    Alan
    Alan Ho
    Former Systems Administrator

  3. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Posting Permissions

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