making a CSV file?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Sofia
Posts: 1
Joined: Thu Mar 10, 2005 4:02 am

making a CSV file?

Postby Sofia » Thu Mar 10, 2005 5:03 am

I've connected to an MS Access database with datalink and password.
When writing SQL queries in trial input and setting some filters it shows the right result in the trial output after pressing trial run button.

But how do I make a CSV file with the trial output result?
Can't figure out how to make the settings for this.

/Sofia

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Mar 10, 2005 10:44 am

Hi Sofia,

You have two options:
1. Put the actual query in a text file, and specify that text file as the input file.

Or, Better,

2. With the Input Filter (the second one), set the Input to come from the Trial run area. Make sure you set the output filter to the filename you want.

Also, you can right-click the Trial Output to save to a file.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Google [Bot] and 6 guests