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",2To 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
APPEND FROM test.txt DELIMITED
CREATE dbfinal.dbf FROM dbtemp.dbf
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
- kbnosurvey kbarchive KB107665