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.
SUMMARY
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:
  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
VFoxWin FoxDos FoxWin 2.50X 2.60X
Properties

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
Feedback