Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying a txt file to a dbf
Message
 
 
À
16/01/1999 19:54:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00176925
Message ID:
00176948
Vues:
22
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform