Easiest way I've found is to create a cursor with your data set up the way you want it and then do a copy to delimited with and give it a filename of vjbtest.txt or whatever.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: Friday, July 18, 2008 7:36 AM To: [email protected] Subject: Re: How to create a .TXT On Fri, Jul 18, 2008 at 7:56 AM, Eurico Chagas Filho <[EMAIL PROTECTED]> wrote: > > I have to create a formatted .txt, some data in specified columns, > with pre-determinate sizes. > What is a good way of doing it ? > In addition to Allen's excellent suggestions, there are the commands COPY TO and EXPORT, which will work if your target file format exactly matches the formats those commands can make. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
