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:
- Open a database table.
- 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