Using php to get a database in access or excel

Discussion in 'PHP' started by dukeofism, Sep 16, 2009.

  1. #1
    Is there a way to take a database that has been populated with information from a php script and export or save that data in a format that can be read by MS Excel or MS access?
     
    dukeofism, Sep 16, 2009 IP
  2. stephan2307

    stephan2307 Well-Known Member

    Messages:
    1,277
    Likes Received:
    33
    Best Answers:
    7
    Trophy Points:
    150
  3. Christian Little

    Christian Little Peon

    Messages:
    1,753
    Likes Received:
    80
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If the database exists you can just connect to it in Excel and run queries directly to pull out the data. Just setup the Data Source or whatever it's called (it'll ask you for the mysql host, username, password). Then you just put in mysql commands right into the query window in excel and it will display the results in a spreadsheet.
     
    Christian Little, Sep 18, 2009 IP