How to Create a Table Structure Using an ASCII File
This article was previously published under Q107665
This article has been archived. It is offered "as is" and will no longer be updated.
You can create a table/.DBF structure from an ASCII text file that containsinformation 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
VFoxWin FoxDos FoxWin 2.50X 2.60X
Article ID: 107665 - Last Review: 02/24/2014 08:18:06 - Revision: 2.1
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
Keywords: kbnosurvey kbarchive KB107665