How to Create a Table Structure Using an ASCII File

Article translations Article translations
Article ID: 107665 - View products that this article applies to.
This article was previously published under Q107665
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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

Properties

Article ID: 107665 - Last Review: February 24, 2014 - Revision: 2.1
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
Keywords: 
kbnosurvey kbarchive KB107665

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com