-
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
%>
-
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
-
Forum Rules
|
|