Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I have table(s) in Access '97 and am trying to export/import them to VFP 6.0 but seem to be losing my long field names. Is there a way to preserve them?
>
>TIA
How are you exporting/importing?
You could create the table structure first and then just transfer the data. SPT or ADO could work for this, although with ADO you would have to replace invalid characters (like spaces) with something else. SPT does it for you. Heck, with SPT you can COPY TO myTable DATABASE myDB if you don't have any weird fields in your MDB.
The other restriction is that you need to put the tables in a DBC, since free tables have a 10 character max on field names.
Précédent
Suivant
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