How do I go about making an application accessing Excel data?

Discussion in 'Programming' started by cre8ive, Jun 10, 2008.

0
  1. #1
    My client uses Excel to keep track of variety of tasks and does simple calculations. What I need to do is to access this data and make a couple of rather elementary applications. Am I supposed to use ODBC here? If I want to make this application using Microsoft Access, how do I go about this? If I want to make it using php running on Apache, how do I go about this?
     
    cre8ive, Jun 10, 2008 IP
  2. algaidaman

    algaidaman Active Member

    Messages:
    106
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #2
    It's a real pain. Honestly, I would see about getting the application built in mySQL with a web interface for them.
     
    algaidaman, Jun 10, 2008 IP
  3. ustas

    ustas Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    What the type calculation in clients excel files? (need samples)
    Want convert excel in our database or other manipulation with data from excel assumed?
     
    ustas, Jun 12, 2008 IP
  4. cre8ive

    cre8ive Peon

    Messages:
    295
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I've been thinking this over, and maybe it's not necessary that we pull out data, use it in a different application (whether it's made using Java, PHP, .Net or whatever). I'm thinking that maybe I can just write small applications (or application-ish forms) using VBA. Possible?
     
    cre8ive, Jun 12, 2008 IP
  5. ustas

    ustas Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #5
    Certainly possible. VBA optimum choice for similar tasks during work with MS office application (Word, Excel, Access, PowerPoint, Outlook).
     
    ustas, Jun 13, 2008 IP