Microsoft KB Archive/107665: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - """ to """) |
||
| Line 54: | Line 54: | ||
<br /> | <br /> | ||
For example, assume you have the following ASCII text file, TEST.TXT: | For example, assume you have the following ASCII text file, TEST.TXT: | ||
<pre class="fixed_text"> | <pre class="fixed_text"> "Name","C",15 | ||
"Age" ,"N",2 | |||
</pre> | </pre> | ||
To create a table/.DBF structure using TEST.TXT, do the following: | To create a table/.DBF structure using TEST.TXT, do the following: | ||
Latest revision as of 10:30, 20 July 2020
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
