Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying a txt file to a dbf
Message
De
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:
00176944
Vues:
30
>>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.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform