Visual FoxPro via ODBC, #Deleted records, yet works in Excel

[David D]

So, I'm trying to link to a client's billing system (Ultra32) which uses a
FoxPro back-end.

I've installed the latest Visual FoxPro driver on a machine running Access.

I've created an ODBC link to the data (using every possible combination of
settings). When I open the table in datasheet view, every single field in
every single record says #Deleted. There is exactly the correct number of
records (about 18k).

I'm able to view the table structure, all of the fields, and datatypes. Not
sure if it matters, but two of the fields have a Binary datatype, and the
rest are text (2-18 chars each) and date/time.

If I try to import to a new Access table, instead of link, I get an error
that is along the lines of "the data you're trying to paste is too large".
The import fails and I don't get a table.

Here's the kicker: If I use the exact same ODBC link, but bring it in to
Excel OR look at it through Microsoft Query, all of the data shows up
perfectly!

Any ideas?

-David

 

[Albert D. Kallal]

Also, you have a choice to use from "machine data source".

Are you using free tables, or is this a dbc file?

If it is free tables, try hitting cancel when asked for index.
Have you tried hitting cancel when it ask you for unique column?

You can also test/try copying the dbf file to a different separate
directory. (don't copy the index). Try linking to the ONE file in that new
directory (and, use a folder/path name <= 8 chars in length.