Solved

Export Records To Tab Delimited File Using ASP

Posted on 2008-06-20
5
787 Views
Last Modified: 2012-05-05
I have a table of date (products) which i need to export to a CSV file with the click of the a button.  This will generate the tab delimited file on the server which is then picked up automatically by another application.

My question is how to write this script to create the text file.  I have full access to the server to create permissions etc.

Basically my code would be something like the code snippet attached, the bit where i have TextFile.AddNew is the part i dont know how to do.

Regards,
Carl

<%

Set RS = Server.CreateObject("ADODB.Recordset")

SQL = "SELECT * FROM tblTempProducts"

RS.Open SQL,Connection,3,3

Do While Not RS.EOF

 TextFile.AddNew

   ProductID, ProductName, Price, TaxRate, Weight

 TextFile.Update

RS.MoveNext

Loop

RS.Close

Set RS = Nothing

SQL = " "

%>

Open in new window

0
Comment
Question by:net-workx
  • 3
5 Comments
 
LVL 15

Expert Comment

by:dosth
ID: 21832835
0
 
LVL 29

Accepted Solution

by:
rdivilbiss earned 500 total points
ID: 21832923
More specifically.
<%

Dim fso, TextStream, path, fldr, Folder
 

Set fso = Server.CreateObject("Scripting.FileSystemObject")

path = Server.MapPath("/pathtofile/")

Set fldr = fso.GetFolder(path)

Set TextStream = fldr.CreateTextFile("test.txt")

Set RS = Server.CreateObject("ADODB.Recordset")

SQL = "SELECT * FROM tblTempProducts"

RS.Open SQL,Connection,3,3

Do While Not RS.EOF

	TextStream.WriteLine  rs("ProductID") & chr(9) & rs("ProductName") & rs("Price") & chr(9) & rs("TaxRate") & chr(9) & rs("Weight")

rs.movenext

loop

RS.Close

Set RS = Nothing

SQL = " "

TextStream.Close

Open in new window

0
 
LVL 29

Expert Comment

by:rdivilbiss
ID: 21833008
0
 

Author Closing Comment

by:net-workx
ID: 31469215
Thanks for your prompt response, exactly what i needed - a nice and easy to follow guide to get me started....  
0
 
LVL 29

Expert Comment

by:rdivilbiss
ID: 21837972
Thank you for the points and good luck with your project.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now