Output Information

FH records can be exported to a variety of external data formats, including text, DBF, and spreadsheet formats directly from any existing browse query. You can also create a browse query specifically for exporting records to an external format.

  1. Select the Tools menu, Queries option.
  2. Highlight the desired query.

  3. Press Run.

    The Query form is displayed.

  4. Do one of the following.

    1. Press Options, then select Output to...

      The Output Query to form is displayed. The output options are:

      • Default Printer
      • Select Printer
      • ASCII File (Comma Delimited)
      • ASCII File (Space Delimited)
      • ASCII File (Tab Delimited)
      • Data Table (Visual FoxPro)
      • Data Table (FoxPro 2.0 - 2.6)
      • Data Table (dBase Compatible)
      • Spreadsheet (Lotus Spreadsheet)
      • Spreadsheet (Microsoft Excel)
      • HTML Document

      Note: Memo fields (narratives) are not included in ASCII and spreadsheet formats unless you use a custom expression for the memo field. Use the PAD function to include the memo field entry. There is a 254 character limit.

      Information on the PAD function is available in P.

    2. (If an external file data format is chosen) In the Save As... dialog box, name the file, then press Save.

      The path and file name is inserted into File....

    3. Press OK to output the query.
    1. Press . All records are placed in the Windows clipboard.
    2. Press OK.
    3. Open application to paste the records in (generally a spreadsheet), then paste the records.

    Note: The Query form is also accessed when accessing records. You can output information from FH from the Query form regardless of how it is accessed.

 

Related topics: