Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mystery Table Import Woes
Message
De
22/01/2006 18:28:44
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
22/01/2006 14:34:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01089237
Message ID:
01089260
Vues:
35
>So I fire up Access 2003 and do the File>Import thing with files of type dBase IV, and sure enough, it pulls them right in, no questions asked. So now I could bring them all into Access then from there into VFP, but I’ve got 19 sets of data, and each set has over 300 data files, and I’m too old to deal with all that before I die.
>
>Anybody have any better ideas?

So if you can pull them from Access... does Access see the whole dataset or you have to import table by table? If it does see them all, then when you pull up a connection to the Access' .mdb (via ODBC from fox), there should be some SQL* function to find all the tables in the .mdb - ah, here it is, SqlTables(). Then you should be able to pull them one by one automatically, and then repeat the proces only 19 times. So you'd only have to do the import to Access manually - despite my convictions (lazy programmer of the 2nd kind), it's not worth automating.

If Access can import them only one table at a time... try to find a OleDb client for these tables. These should be freely downloadable.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform