Post reply

ADO & Bookmarks in SQL ?

  • December 27, 2003 at 7:19 am

    #177385

    I would like to populate an Excel spreadsheet with data from a query. I loop through the recordset to display the records in ASP, but I heard there is a way to do this in SQL by using bookmarks (adBookmark) maybe in a stored procedure. Any ideas? Thank you !

  • December 30, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • December 30, 2003 at 8:43 am

    #488199

    Using Microsoft Query with Excel, you can tie a query to a spreadsheet, and this gets around having to use ADO. Is this not an option?

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • December 30, 2003 at 9:46 am

    #488215

    I do this all the time.

    Just open excel and click on the

    Data, Get External Data, New Database Query

    Then pick the ODBC Conection to the database you want to access. Click close when on the tables dialog. Then click the SQL button. Paste your query in the the bax and click OK.

    Then click the exit door and the data will be returned to your spreadsheet.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply