Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: convert txt
Thread ID: 205708 Message ID: 205709 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Sunday, November 30, 2008 1:29:58 PM         
   


> hi all,
>
> i need to convert many text files to dbf ,
>
> if i have text files as t1,t2,t5,t35,t58 is ther away to convert it to tables at the same code(time)
>
> thanks

How the data in text files is stored, I mean delimter type?

You should have same number of fields as columns in the text file and the fields/column order too. You can try the following command:

USE T1
APPEND FROM t1.txt TYPE DELIMITED


Regards,
akram



COMPLETE THREAD
convert txt Posted by mohammed qasem @ 11/30/2008 1:14:03 PM
RE: convert txt Posted by M. Akram Bhatti @ 11/30/2008 1:29:58 PM
RE: convert txt Posted by mohammed qasem @ 11/30/2008 1:56:13 PM
RE: convert txt Posted by M. Akram Bhatti @ 11/30/2008 2:30:38 PM
RE: convert txt Posted by mohammed qasem @ 12/1/2008 9:11:26 AM