Microsoft KB Archive/114313

{| = How to Use RQBE to Output a Query to an ASCII Text File =
 * width="100%"|

ID: Q114313

2.50 2.50a 2.50b 2.60 | 2.00 2.50 2.50a 2.50b 2.60

WINDOWS              | MS-DOS kbprg The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6

To direct the ouput of a FoxPro query within the Relational Query By Example (RQBE) tool to an ASCII text file, do the following:

1. Set up your query within the RQBE window.

2. From the Output box, select Report/Label.

3. Select the Options check box.

4. In the RQBE Display Options dialog box, select the Screen Display radio

button. 5. Under Output Destinations, select the To File check box. 6. Type a name for your file (for example, ASCII.TXT).

7. Choose OK twice, then choose the Do Query button to create your file.

To see the code generated by these settings, choose the See SQL button. You can copy and paste this code into a program. It will look something like:

SELECT from  to FILE <![CDATA[