Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import VFP data into Excel and Access
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00871506
Message ID:
00871512
Vues:
15
For Access, you can define an ODBC connection to your table or your DBC and use that connection in Access to import the data.

For Excel, you can use this command if your table has less than 16K records:
COPY TO MyExcel.XLS TYPE XL5
Note: I don't know if this restriction is still valid in VFP 8.0.

HTH

>We are finally migrating our FPW 2.6 application to VFP 8.0, but have users that still access the old style dbf files using Access 97 and Excel 2000. I would like to recommend product upgrades (to Access 2003 and Excel 2003) and any driver updates, so that the users can access the new VFP 8.00 tables (with a DBC). So my questions are as follows (Basically what works and how to set it up):
>
>1) Can Access 2003 import from a VFP 8.0 free table?
>2) Can Access 2003 import from a VFP 8.0 table in a DBC?
>3) What special drivers or setup (if any) is required to support the import from Access?
>4) Is there different version of Access that would be better?
>
>5) Can Excel 2003 import from a VFP 8.0 free table?
>6) Can Excel 2003 import from a VFP 8.0 table in a DBC?
>7) What special drivers or setup (if any) is required to support the import from Excel?
>8) Is there different version of Excel that would be better?
>
>Thanks for your help!
>
>Doug Gould - Banfield, The Pet Hospital
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform