Solved

Export Records To Tab Delimited File Using ASP

Posted on 2008-06-20
5
775 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

19 Experts available now in Live!

Get 1:1 Help Now