EXCEL TO SQL php My Admin

Discussion in 'Databases' started by KIKAN, Oct 28, 2009.

0
  1. #1
    Hello Friends I have A Excel Work Book On My Pc i want to export its data to my web server of www.seedtofeed.co.cc and that should transfer in seconds so any one help me how can i export

    SERVER CONFIG
    • cPanel Version 11.24.5-STABLE
    • cPanel Build 38506
    • Theme x3
    • Apache version 2.2.13 (Unix)
    • PHP version 5.2.11
    • MySQL version 5.0.81-community
    • Architecture x86_64
    • Operating system Linux
    • Shared Ip Address 69.175.11.34
    • Path to sendmail /usr/sbin/sendmail
    • Path to PERL /usr/bin/perl
    • Kernel version 2.6.27.10-grsec
     
    KIKAN, Oct 28, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Use Navicat, you can import from Excel and about 30 other data types - http://www.navicat.com

    They have a free personal version, and a free 30 day trial.
     
    Last edited: Oct 28, 2009
    jestep, Oct 28, 2009 IP
  3. KIKAN

    KIKAN Peon

    Messages:
    92
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thx I Will Try
     
    KIKAN, Oct 28, 2009 IP
  4. kimmy1986

    kimmy1986 Peon

    Messages:
    45
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You can convert excel file to csv then import it in mysql
     
    kimmy1986, Oct 28, 2009 IP
  5. KIKAN

    KIKAN Peon

    Messages:
    92
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    its not refreshing automatically help me
     
    KIKAN, Oct 28, 2009 IP
  6. KIKAN

    KIKAN Peon

    Messages:
    92
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Navicat not auto updating help me
     
    KIKAN, Oct 29, 2009 IP
  7. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #7
    What do you mean by auto-updating?
     
    jestep, Oct 30, 2009 IP
  8. KIKAN

    KIKAN Peon

    Messages:
    92
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    it should update every sec automatically
     
    KIKAN, Nov 2, 2009 IP
  9. fujipadam

    fujipadam Guest

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #9
    Lets make sure we understand your question first

    ok so you are not looking to upload an Excel to the server one time. You want to keep the server in sync with the desktop excel? i.e. each time you add something to excel you want to be able to update the server automatically? Did I get that right?
     
    fujipadam, Nov 5, 2009 IP
  10. KIKAN

    KIKAN Peon

    Messages:
    92
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #10
    YES RIGHT SIR


    fujipadam Help Me Plz
     
    KIKAN, Nov 5, 2009 IP
  11. fujipadam

    fujipadam Guest

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #11
    yeah thats a bit tricky - but basically you can do one of 2 things I guess

    1) each time excel is updated you can have somekind of a software to upload it to mysql ... that will get hairy fast, so dont think I would recommend it

    2) Use Excel to connect to mysql directly using ODBC. its been years since I did ODBC stuff but I think the following website might help

    http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/

    Fuji


    But then you can also ask yourself why you have a local excel if you want to update mysql. you can create a php script to update Mysql and display the data. But you know your business a lot better than I do :)
     
    fujipadam, Nov 5, 2009 IP