> > 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
>
> Jim,
> IMHO trying to get VFP data from Access 2007 does help you only to lose hairs. Instead (if you wouldn't use
> VFP coding to send to Access, some HTML or .Net code doing that ...) use Excel to get the data first and then get from Excel. It is ridicilous you can easily use an UDL file from Excel but not from Access (maybe expreinced users can do it through adp files).
>
> -You should first forget using ODBC and download VFPOLEDB driver
> -Open Excel
> -Data\From other resources\From Data connection wizard
> -Select Other/Advanced [Next] "Microsoft OLEDB providder for Visual FoxPro" [Next]
> -Complete it specifying the database in 'Connection' tab
>
> And maybe it would be much easier to install SQL server express and a linked server to VFP. Then you could use ODBC to SQL server (provided you need this for querying only). Another easy option is to use ODBC drivers from Sybase 'Advantage Database'. Sybase kindly published the ODBC and OLEDB drivers that can work with VFP tables (local server mode is free).
>
> Cetin Basoz
Cetin,
I can get the data into Excel and then import the data into Access, but I'll need to open the Excel file every time I want to refresh the data, which is awkward.
I've successfully managed to connect in Excel using the OLEDB, what advantages does it have over ODBC?
I'll give the SQL server express route a shot.
Thanks for the advice,
Jim