Foxpro - VB - Access what do I need?
- From: "James Houston" <houstjd@xxxxxxxxx>
- Date: Fri, 8 Apr 2005 14:19:31 -0700
I have an app written in VB6 that manages data exchange between 3 different
applications, each of which uses a different DB format. Briefly:
1. Data entry is done using an ancient DOS app called DataEase. DataEase
will not directly interact with any modern db, but it can export a text
file. Once the user has finished their data entry session, the data is
written to a text file.
2. My app watches for any changes in the export file and imports the data
into an Access 97 db.
3. After manipulation, the data is then appended to an application that
uses Foxpro 2.0 tables. The Foxpro tables are linked to the Access 97 db via
ODBC. Therein lies my problem.
The Foxpro app in this scheme has to be upgraded to a newer version that
uses Foxpro 6 tables. I've tried to get FP6 to talk to Access 97 via ODBC
in the past, and couldn't get it to work. Ditto using ADO. Now that I'm
being forced to upgrade, I'm getting ready to try it again. The first two
links in this chain, the DOS and Access 97 apps will remain largely
unchanged. Just to make sure I've got everything set up correctly can
someone tell me what I'll need to to read and write to a Foxpro table via
ODBC? The Foxpro tables are free tables with CDX style indexes.
Any help or advice would be greatly appriciated.
Best
Jim
.
- Follow-Ups:
- Re: Foxpro - VB - Access what do I need?
- From: Cindy Winegarden
- Re: Foxpro - VB - Access what do I need?
- Prev by Date: Re: Problem with TEXT column data
- Next by Date: Bill Vaughn's "ADO Command Strategies" from 10/2000
- Previous by thread: ADO: Error: System resource exceeded.
- Next by thread: Re: Foxpro - VB - Access what do I need?
- Index(es):
Relevant Pages
|
