Need solutions...

Discussion in 'Databases' started by contactamy, Sep 25, 2008.

  1. #1
    I want to make a program that can search perticular data from excel file.

    I mean i have to take EXCEL sheet as a backend. So my problom is with which frontend i can do this. Which frontend provide connectivity with excel...:confused:

    Thanks
     
    contactamy, Sep 25, 2008 IP
  2. kind_of_the_cash

    kind_of_the_cash Active Member

    Messages:
    852
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    85
    #2
    Can do it with visual basic on windows other wise use php on web interface , hope that help
     
    kind_of_the_cash, Sep 25, 2008 IP
  3. SEOpaw

    SEOpaw Peon

    Messages:
    437
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    convert all excel files to csv, upload them to your server

    you can do php to load csv file and implode it

    then kapish you got the search word in excel
     
    SEOpaw, Sep 25, 2008 IP
  4. vasago

    vasago Peon

    Messages:
    95
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If those Excel files would be frequently updated and converting them all the time is not an option, I guess ASP would be your best choice.
     
    vasago, Sep 26, 2008 IP
  5. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Assuming an All Microsoft hostign Stack
    Put the file or folder in an Index on the Server and call the Indexing Server API from you ASP(.net) code.
    Make an ODBC datasource using an Excell sheet and call this ODBC datasource from ASP(.net) code.

    I am not an expert but I know the first option can be done the second should be possible as well.

    Hope this helps
     
    chisara, Sep 28, 2008 IP
  6. The Stealthy One

    The Stealthy One Well-Known Member Affiliate Manager

    Messages:
    3,043
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    105
    #6
    Microsoft Access can do this.
     
    The Stealthy One, Sep 28, 2008 IP