Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107665

From BetaArchive Wiki
Knowledge Base


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:

  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



Additional query words: VFoxWin FoxDos FoxWin 2.50X 2.60X

Keywords: KB107665