Linking Foxpro

[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

 

[Cindy Winegarden]

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?

 

[Dave]

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

 

[Dave]

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

Dave

 

[Cindy Winegarden]

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.

 

[Dave]

What if there is a User ID involved?
Would this allow me to see some data, but not others?

 

[Cindy Winegarden]

No, Fox tables don't have security on the column level.

 

[Cindy Winegarden]

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.

 

[Dave]

Thanks for all the input Cindy!!

Dave

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.