You can use the COPY TO function to copy all fields or only certain fields to a variety of output formats. The CSV and SDF are the two output formats you might be most interested in.
>Hi All:
>
>How do I copy all fields and column or a specific field and column from a table to a text file. Thanks in advance.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi