how to develop simple download operation

[najmi]

hi guys..i`m newbiesin this field.i would to ask anyone who have an idea how to do a simple download operation where the data in the ms access.or maybe you have a good website that can help me

[Elavarasi]

hi guys..i`m newbiesin this field.i would to ask anyone who have an idea how to do a simple download operation where the data in the ms access.or maybe you have a good website that can help me

U cant directly download ms Access ...
either u convert to textfile or excel file.. then download

try with this


dim Cn,Rs
set Cn=server.createobject("ADODB.connection")
set Rs=server.createobject("ADODB.recordset")
Cn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("db1.mdb")
Rs.open "select * from table",Cn,1,3

Response.ContentType ="application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment; filename=En_List.txt"

if Rs.eof <> true then
while not Rs.eof
response.write(Rs.fields("f1")& " - " & Rs.fields("f2") & vbcrlf )
Rs.movenext
wend
end if
set rs=nothing
Cn.close

[najmi]

U cant directly download ms Access ...
either u convert to textfile or excel file.. then download

try with this


dim Cn,Rs
set Cn=server.createobject("ADODB.connection")
set Rs=server.createobject("ADODB.recordset")
Cn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("db1.mdb")
Rs.open "select * from table",Cn,1,3

Response.ContentType ="application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment; filename=En_List.txt"

if Rs.eof <> true then
while not Rs.eof
response.write(Rs.fields("f1")& " - " & Rs.fields("f2") & vbcrlf )
Rs.movenext
wend
end if
set rs=nothing
Cn.close

thanks a lot my friends..ok the situation like this..i have put a software or application in my ms acess db..so if anyone interested with this particular software or application, they can download this sofware..so,my problem is,how to do this download..i hope you can understand what i`m try to tell you..thank again

[jhardman]

thanks a lot my friends..ok the situation like this..i have put a software or application in my ms acess db..so if anyone interested with this particular software or application, they can download this sofware..so,my problem is,how to do this download..i hope you can understand what i`m try to tell you..thank again

Look up the ADO.STREAM object. It was designed for this purpose, but I myself have never used it.

Jared