Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    c q
    c q is offline
    Regular Coder
    Join Date
    Jun 2002
    Location
    Mumbai, India
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    anyway to get contents of a .xls file into a mysql db ?

    I have a huuuuuuge .xls file. Is there any shortcut method I can incorporate its contents into mySQL ?
    ....help ???

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Use Excel to export it as a CSV file and then use phpMyAdmin if you have it to import it into MySQL.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    c q
    c q is offline
    Regular Coder
    Join Date
    Jun 2002
    Location
    Mumbai, India
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts
    emmm....what might be this phpMyadmin ?

  • #4
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    It's an application written in php to administer MySQl databases

    http://www.phpmyadmin.net/

    Many web hosts provide it for you. If not you can download and install it yourself.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #5
    c q
    c q is offline
    Regular Coder
    Join Date
    Jun 2002
    Location
    Mumbai, India
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts
    cannot find server or DNS err
    but I also hit a google search and foound the same link...maybe some prob. with their server lol

  • #6
    New to the CF scene
    Join Date
    Sep 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts


  •  

    Posting Permissions

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