Import data in CSV file
Hello,
This is Zeeshan Ahmed from itHighway. I have an application with my sql database containing about 30000 members records. There are 120 fields for in members table.
I have developed a script to download members data in CSV file but the problem is it only download only 800, 1000 or 1200 members records and after that the download is terminated.
I need to download all 30000 records in CSV file. Is there any solution to the issue I am having?
At the end of this post I have posted a few important lines from my download script.
Any idea..
Any help..
Will really be appriciated..
Thank you
Zeeshan Ahmed
itHighway
================================================== ======
================================================== ======
================================================== ======
Response.Expires = 0
server.ScriptTimeout = 1000
Response.Buffer = false
Response.ContentType = "text/csv"
Response.AddHeader "Content-Disposition", "attachment;filename=Members.csv"
set rAdmin = CONN.execute("SELECT * FROM MEMBERS")
txtA = "Phone Number,E-mail,Name,Street,"
response.Write(txtA)
txtA = "Info1,Info2,Info3,Info4,Info5,Info6,"
response.Write(txtA)
...................
............................
do while NOT rAdmin.EOF
txtB = ""& rAdmin("PHONE_NUMBER")
txtB = txtB + ","& rAdmin("EMAIL")
txtB = txtB + ","& rAdmin("NAME")
txtB = txtB + ","& rAdmin("STREET")
response.Write(txtB)
...................
............................
rAdmin.MoveNext
loop
|
