Microsoft KB Archive/107665

= How to Create a Table Structure Using an ASCII File =

Article ID: 107665

Article Last Modified on 12/3/2003

-

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

-



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:  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



Additional query words: VFoxWin FoxDos FoxWin 2.50X 2.60X

Keywords: KB107665

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.