Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying a txt file to a dbf
Message
From
16/01/1999 20:03:42
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00176925
Message ID:
00176948
Views:
20
>>>Hi Michielle,
>>>
>>>>I have a large text file that I need to turn into a dbf. The "fields" are a fixed length, but there are extra spaces so it's not strictly delimited. Is there a way to import this into a dbf where the fields are already set using the lengths of the fields to determine what text goes in which field?
>>>
>>>What does the text look like? Could this be a SDF file?
>>>
>>>Christof
>>
>>I'm currently trying it as a SDF file, but in case that doesn't work, I'm looking to see if there's a better way that I missed.
>>
>>There's 792,502 records in this file. Is there a way to append only a few of the records for testing purposes?
>
>The easiest thing to do would be to open the file with an editor and simply copy a small number of records into another file without reformatting, and then play with the copy that contains the few records you copied.

Yeah, that would have been a good idea if I had seen it before I got it to work. :)

Thanks,

-Michelle
Previous
Reply
Map
View

Click here to load this message in the networking platform