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