Getting SQL data into Excel

Results 1 to 2 of 2

Thread: Getting SQL data into Excel

  1. #1
    Kentium Guest

    Default Getting SQL data into Excel

    I&#039;m building a little credit application form for Accounting. They want me to store the data in a database (they don&#039;t care what DB, but i&#039;m using MS SQL).<BR><BR>They would like to be able to hit a button that says- "Download Data in Excel Format" so that they can manipulate (run reports) on the data in Excel.<BR><BR>Is there an easy way to do this? My thinking is to open a connection to my SQL database, retrieve the recordset, and then insert a comma (delimit) the data, and store it in a text file using FSO.<BR><BR>Is this the best way?<BR><BR>Thanks everyone!

  2. #2
    Join Date
    Dec 1969

    Default RE: Getting SQL data into Excel

    Depends. That will certainly work. If all task parameters ( table definitions, fields, etc. ) will always be the same, you could open SQL from access with a macro and use ADO to perform the operation , and choose a custom file name each time.

Posting Permissions

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