How to Create a Table Structure Using an ASCII File

ID: Q107665

2.50 2.50a 2.50b 3.00 | 2.00 2.50 2.50a 2.50b | 2.50X 2.60X

WINDOWS               | MS-DOS                |MAC

The information in this article applies to:

• Microsoft Visual FoxPro for Windows, version 3.0
• Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for Macintosh versions 2.5x and 2.6x

You can create a table/.DBF structure from an ASCII text file that contains information about the structure.

For example, assume you have the following ASCII text file, TEST.TXT:

   "Name","C",15
   "Age" ,"N",2

1. Open a database table.

2. In the Command window, type the following commands:

      COPY STRUCTURE EXTENDED TO dbtemp.dbf
      USE dbtemp.dbf
      ZAP
      APPEND FROM test.txt DELIMITED
      CREATE dbfinal.dbf FROM dbtemp.dbf
      BROWSE

Keywords          : FxprgBrowse 
Version           : 2.50 2.50a 2.50b 3.00 | 2.00 2.5
Platform          : MACINTOSH MS-DOS WINDOWS