Web Development

Ask something
Discussion Locked

Access vs foxpro tables

0 helpful
3 replies

by phdj2000 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have an access97 application that imports data from FoxPro for dos 2.6 tables. It works fine.
The Access aplication has been migrated to Asscess2002 and now it doesn't work fine because for some reason Access2002 doesn't seem to have the drivers to read the FoxPro table's memo file.
Does anybody know of a wat around this problem please?

3 replies

by nikki96

Found on Usenet...
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=utf-8&selm=2pwF9.2630%24S87.11262%40news1.mts.net

From: Bill S. (BillS@mts123.com)
Subject: Re: AccessXP foxpro 2.6 .dbf driver?

View this article only
Newsgroups: comp.databases.ms-access
Date: 2002-11-28 14:03:49 PST

In Access 2000 you can use the Visual FoxPro ODBC driver as follows to link
to Fox 2.6 and previous (I may have left out some minor/obvious steps):
File->Get External Data->Link Tables
FilesOf Type = ODBC Databases
New Data Source
User or System Data Source
Microsoft Visual FoxPro Driver
Finish

You should at this point get the ODBC Visual FoxPro Setup dialog box
Data Source Name: Whatever you want to call it
Description:However you want to describe it
Database Type: Free Table Directory (Because it is FoxPro 2.6 or less)
Browse to the directory that contains the FoxPro .dbf files or just type the
location (e.g. C:\FoxPro\Data)
Select OK or continue on some dialog boxes that appear at this point
Eventually you will get a Link Tables dialog box that lists the .dbf files
in the selected directory
Select All to select all. the .dbf's
You will then get the prompts asking you to identify the key field in each
table.

Tried this with Access 2000 and FoxPro 2.6 just to be sure and it worked
fine.

by phdj2000

Nice try but unfortunately the import is done automatically within the application. there's no user interaction.

The access application selects fields from Foxpro tables using an sql statement.

openrecordset(Select table.field, table.field2 from)

Part of the sql statement specifies the path to the data
\\folder\folder\folder'[Fox Pro 2.6;]

The Fox Pro 2.6 part tells access which ISAM to use to read the data.

The Fox Pro 2.6 ISAM is no longer supported under Access2002.

This discussion is closed to new replies.