MS Query via ODBC cannot read Integer field from FoxPro...what's w

C

CJ

I am running Exel 2003, using MS Query on a Foxpro database. Recently
upgraded to VFP 7.4 from 7.3

Now when I run the same exact Query I receive the following message ODBC
VFP/NOT A TABLE. When I extracted the table and looked at the fields I found
a new field type INTEGER.

Is there a new ODBC driver for this problem, or is there some other setting?

Thanks!

CJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to Visual Foxpro V7+ from Access - ODBC no longer works 2
Visual FoxPro via ODBC, #Deleted records, yet works in Excel 1
MS Query and Integer fields 0
ODBC and DBF File in MS Access 8
Linking Access 2003 to Vis. FoxPro w/ODBC 2
Excel query via ODBC, left joins on multiple tables 0
Windows XP, Excel 2000: ODBC driver for Visual FoxPro tables 0
Switching ODBC sources in Excel 2007 1

Top