How to Create a Table Structure Using an ASCII File (107665)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft FoxPro for Windows 2.5
  • Microsoft FoxPro for Windows 2.5a
  • Microsoft FoxPro for Windows 2.5b
  • Microsoft FoxPro for MS-DOS 2.0
  • Microsoft FoxPro for MS-DOS 2.5
  • Microsoft FoxPro for MS-DOS 2.5a
  • Microsoft FoxPro for MS-DOS 2.5b
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:
  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

Modification Type:MajorLast Reviewed:12/3/2003
Keywords:KB107665
©2003 Microsoft Corporation. All rights reserved.