Linking Visual FoxPro 6 to Access2000

J

Jennifer

I use the accounting system ACCPAC, which stores it's data
in FoxPro(6) databases. Can anyone tell me in laymen's
terms, (sorry, not a developer here) how I can link the
FoxPro databases to a Microsoft Access 2000 database?

Here is what I have already tried:
Went to the ODBC DataSource Administrator
Added the Microsoft Visual FoxPro Driver (*.dbf)
Chose the Free Table directory
Set the path to where the foxpro dbf files are located

It added it fine.

Then went to access, chose link data, chose odbc data
Chose the data source name that I used, then a completely
EMPTY Link Tables window opens....no tables to choose
from.

What I am doing wrong??

Thanks in advance!!
 

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

Linked Foxpro tables not editable? 0
Importing FoxPro 2.6 DBF Into Access 2007 1
Problem Linking Foxpro 9 .DBC in Access 2003 7
Importing FoxPro free table, getting around "the field is too small to accept.." error 1
Importing data from a Visual FoxPro 0
How do I use OLEDB to link to a Visual FoxPro file 1
cannot link Foxpro file as table, access2000 3
Visual FoxPro via ODBC, #Deleted records, yet works in Excel 1

Top