Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import VFP data into Excel and Access
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00871506
Message ID:
00871512
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform