Create queries and export the data to Excel

[camillaj]

I have a database with data relations that I want to export to Excel. I know I can export tables directly from Access etc. till Excel, but this data is not very readable.

I want to make some queries to retrieve certain results, maybe store the result in a tmp table, and then export the result to Excel from an ASP page. In this way I can join the tables as I want and create a more readable excel file.

Does anybody know if this is possible or how I could go about doing it?

Thanks a lot for any response to this )

 

[100dtl]

You can retrieve data from excel and then do what you like with it

Set connObj = Server.CreateObject("ADODB.Connection&quot
Set rs = Server.CreateObject("ADODB.RecordSet&quot

connstring = "DRIVER=Microsoft Excel Driver (*.xls);" _
& "DBQ=" & Server.MapPath("yourfile.xls&quot
connObj.Open connstring

filename = "sheet1" ' excel

sql ="Select * From ["&filename&"$]"

'open xls connection
set rs = connObj.Execute(sql)

do while not rs.EOF
'do somemthing here
rs.Movenext
loop

 

[ggriffit]

You could have a look at

http://www.greggriffiths.org/webdev/both/excel/