making a CSV file?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

making a CSV file?

Post by 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: 2230
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by 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

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest