Linking Foxpro

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have download the ODBC drivers and linked to a Table in a Foxpro db.
However the information that is there is zeros.

If I open the table in Foxpro there is data.

However do I link a Foxpro dbf and use the data in Access?

Thanks

Dave
 
Hi Dave,

Are you using ODBC? Be sure you have the latest FoxPro and Visual FoxPro
ODBC drivers, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates.

Do you know which version of FoxPro your tables were created with? Does your
ODBC data source point to a Database Container (DBC file) or a "free table"
directory?
 
I am using ODBC.

I did download the latest drivers.

Is it possible that the FoxPro table is not Visual FoxPro? If it is not a
visual DB, do I use different drivers? I am not certain of the version of
the table. I am using a program, dbfViewer to look at the data, outside of
Access.

I am pointing to a free table.

Thanks for responding

Dave
 
Cindy I downloaded the ODBC at the very bottom that this page - are those
the correct drivers?

Dave
 
Hi Dave,

Yes, those are the correct drivers and they work for all versions of FoxPro
up to VFP6. Over the years new features have been added to the table
structures and are not compatible with ODBC, but if a table created with
VFP7, VFP8, or VFP9 does not use any of the new data features then it will
be compatible with ODBC.

"I am using a program, dbfViewer to look at the data,"
Since you can read your data in dbfViewer there's no telling whether it was
created with FoxPro, or some other Xbase language. Also, Paradox creates
files with a DBF extension. I know that the VFP ODBC drivers won't work with
Paradox tables, but your general purpose dbfViewer might read them
correctly.

How big is your file(s)? If it's small you could zip it up (include the DBF
and the CDX and FPT if they are present) and send it to me at the address
below. I'll see what I can figure out.
 
For the record, Dave sent me a sample of his data offline and in FoxPro and
Visual FoxPro several fields were full of ASC(1) characters, which show as
little boxes or as dark vertical bars in character fields.
 
Thanks for all the input Cindy!!

Dave

Cindy Winegarden said:
For the record, Dave sent me a sample of his data offline and in FoxPro
and Visual FoxPro several fields were full of ASC(1) characters, which
show as little boxes or as dark vertical bars in character fields.
Click to expand...
 
Back
Top