Results 1 to 2 of 2

Thread: Download to Excel

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    24

    Download to Excel

    Trying to download the grid result to an Excel file (or CSV) and when I click the download button, it clears the grid, and does not ask me where I want to save the download file, etc.
    Thanks for your help.

    Attaching the code:

    <%
    Dim Mydb
    Set Mydb=Server.CreateObject("ASP.db")
    MyDb.dbColor = "White,#015181,#9CCFCE,Black,LightGrey,,false"
    Mydb.dbDSN = Session("ConnectionString")
    MyDb.dbDBType = "SQL" ' It is an SQL database

    SQL = "Select * from vw_DownloadVolume "
    SQL = SQL & "where monthlogged = '" & monthdesc
    SQL = SQL & "' and yearlogged = '" & yeardesc & "'"

    MyDb.dbSQL = SQL
    MyDb.dbGridInc=20
    MyDb.dbMode = "grid"
    MyDb.dbGridHideFlds = "0,1,8,12,16,20,24,28,32,36,40,44,48,52,56"
    NM="TypeDesc,Description;Volume, Volume;NonC,Nonconformance"
    MyDb.dbNameMap = NM
    MyDb.dbOptions = "HeaderFontTag=Face=Verdana Size=2,CellFontTag=Face=Verdana Size=2"
    Mydb.dbCSVName = "Volume.csv"
    Mydb.dbNavigationItem = "Next, Prev, Download"
    Mydb.dbNavigationIcon = "std"
    MyDb.dbSuppressMsg = true
    MyDb.dbImageDir="../../images/"
    MyDb.dbSuppressMsg = true
    MyDb.ASPdb

    %>

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    This question sounds very familiar. Search for excel in this forum and check for th esolution. I think you can set some brower setting to do that.

    FK

Posting Permissions

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