> Hello,
>
> I'm attempting to query a VFP database from Access 2007. When I try to import from a table using 'external data > more > ODBC database' I can choose the table from the database but I'm presented with an error message saying
>
> 'Invalid field definition 'DELETED()' in definition of index or relationship'.
>
> Any thoughts as to what's causing this would be much appreciated. I've successfully queried the database using Excel, but I'd like to be able to make more presentable reports based on the query.
>
> I'm connecting using the Visual FoxPro Driver under 'machine data sources'.
>
> Many thanks
>
> Jim


You add SET DELETED in the connection by adding ;DELETED=Yes; to the string.
You should probably not use VFPODC at. It's not been updated sin VFP6. Today we use VFPOLEDB.DLL instead with an ADODB.Connection oobject.
The latest version of VFPOLEDB is version 9 and can be downloaded from Microsoft.

-Anders