Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement