linking FoxPro Tables with ODBC

[Christoph Keller]

Hi NG

I'm desperately need to link some free foxpro tables
into my access 2000 application.

Here is what I did:
1) I downloaded the newest ODBC 6.01.8....
2) Control Panel->ODBC->SystemDSN: new "myODBC", free tables, path to
"C:\mytables"
3) in Access: File->external data->link->odbc, "myODBC"
4) the appearing list is EMPTY - None of the existing Foxpro Tables in
"C:\mytables" are listed!

Why not? What's the problem? Am I just too stupid? How many more hours of my
young life
should I waste for this problem? I would very much appreciate any help!

Chris

 

[Cindy Winegarden]

In [email protected],

I'm desperately need to link some free foxpro tables
into my access 2000 application.

Here is what I did:
1) I downloaded the newest ODBC 6.01.8....
2) Control Panel->ODBC->SystemDSN: new "myODBC", free tables, path to
"C:\mytables"
3) in Access: File->external data->link->odbc, "myODBC"
4) the appearing list is EMPTY - None of the existing Foxpro Tables in
"C:\mytables" are listed!

Hi Chris,

Is there a DBC file present in your directory? If so, the DBFs belong to a
"Database Container" and won't show in your list when you choose the free
table option.

You can test the free table option by creating an Excel spreadsheet and
saving as a dBase IV DBF. You should be able to see that table.

 

[Christoph Keller]

Cindy

Thank you for answering.
I've read a lot of your messages in "DejaNews.com" lately.

I *guess* there is no DBC in the directory. All I have from a customer
are DBFs. A shareware dbf-viewer can handle the files and it shows the
following DB-Info:
*
Filename C:\Daten\HALTER.DBF
Type FoxPro with memo
Last modified 07.06.04
File size 7036199
Header size 1249
Record size 1370
Record count 5135
Field count 38
Memo field count 2
*

An other file, that work fine with my ODBC Driver has the following
DB-Info:
*
Filename C:\Daten\HALTERalt.DBF
Type FoxPro with memo
Last modified 24.08.00
File size 1007383
Header size 1057
Record size 666
Record count 1511
Field count 32
Memo field count 1
*
The dBase IV DBF exported from Excel works fine as well
Does this make sense to you? Do I have a version conflict?
Thank you again for your kind support

Chris

 

[Cindy Winegarden]

In [email protected],

I *guess* there is no DBC in the directory. All I have from a customer
are DBFs. A shareware dbf-viewer can handle the files and it shows the
following DB-Info:
*
Filename C:\Daten\HALTER.DBF
Type FoxPro with memo
Last modified 07.06.04
File size 7036199
Header size 1249
Record size 1370
Record count 5135
Field count 38
Memo field count 2
*

An other file, that work fine with my ODBC Driver has the following
DB-Info:
*
Filename C:\Daten\HALTERalt.DBF
Type FoxPro with memo
Last modified 24.08.00
File size 1007383
Header size 1057
Record size 666
Record count 1511
Field count 32
Memo field count 1
*
The dBase IV DBF exported from Excel works fine as well
Does this make sense to you? Do I have a version conflict?

From the stats above, your tables do not appear to be part of a DBC, but I
don't have a lot of experience calculating table sized. Another problem
might be a mismatch between the number of records in the table as stored in
bytes 4-7 in the header, and the actual number of records, although I don't
know how ODBC handles this.

I've hunted for other advice/solutions and haven't had any luck.