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.
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM tblTempProducts"
Do While Not RS.EOF
ProductID, ProductName, Price, TaxRate, Weight
Set RS = Nothing
SQL = " "