[AccessD] Export Queries to Text file

Would you believe Occam's Razor.

Gustav Brock wrote:

>Hi Jim
>
>"Failed to mention .."? You bet. 
>How could Marty know this? 
>
>/gustav
>
>  
>
>>>>JHewson at karta.com 28-12-2005 21:21:11 >>>
>>>>        
>>>>
>Thanks, that works!
>What I failed to mention in my first message is that the queries are in a third party "Access" interface.  While it is Access (ODBC to Oracle), it has a completely different interface with everything locked down tight.  No way of writing any code.
>Thanks again.
>
>Jim 
>jhewson at karta.com 
> 
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>Sent: Wednesday, December 28, 2005 1:54 PM
>To: accessd at databaseadvisors.com 
>Subject: Re: [AccessD] Export Queries to Text file
>
>Hi Marty
>
>Oops, a little rusty in DOS mode?? 
>In fact it's even simpler:
>
>copy a.txt+b.txt+c.txt final.txt
>
>/gustav
>
>  
>
>>>>martyconnelly at shaw.ca 28-12-2005 20:22:57 >>>
>>>>        
>>>>
>Use Shell function out to DOS
>xcopy a.txt+b.txt+c.txt > final.txt
>I think that is the syntax
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada