Knowledge Base |

# How to Create a Table Structure Using an ASCII File

Article ID: 107665

Article Last Modified on 12/3/2003

APPLIES TO

- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.5b for MS-DOS
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b for MS-DOS

This article was previously published under Q107665

## SUMMARY

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

To create a table/.DBF structure using TEST.TXT, do the following:

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`

Additional query words: VFoxWin FoxDos FoxWin 2.50X 2.60X

Keywords: KB107665