Re: Connecting to a FoxPro DBF file
From: Cindy Winegarden (cindy_winegarden_at_msn.com)
Date: 11/23/04
- Next message: Thomas: "Re: Windows XP SP2 MDAC 2.8 SP1"
- Previous message: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- In reply to: Duncan: "Re: Connecting to a FoxPro DBF file"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 10:43:13 -0500
Hi Duncan,
FoxPro tables come in 3 parts. The table itself is a DBF file. Indexes, if
there are any, are in a CDX file with the file name matching the table name,
and contents of Memo data type fields, if there are any, are in FPT files.
The FoxPro data engine will open the CDX and FPT files automatically if
information in the DBF's header says that they should be present.
That's why you needed the CDX in the same folder.
-- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com "Duncan" <ddimech@ads.com.mt> wrote in message news:u0rNPoU0EHA.2788@TK2MSFTNGP15.phx.gbl... > Dear All, > thanks for your replies. Me and a collegue have spent some additional > hours > to solve this issue and funnily we did. Why funnily? Simply because we > changed the SQL table to the full file path at it worked and this was done > by mistake and we wanted to share this with you > > The connection string remains the same but the SQL now is "Select * from > c:\client.dbf" > > Please note that you need clients.cdx also in the same folder
- Next message: Thomas: "Re: Windows XP SP2 MDAC 2.8 SP1"
- Previous message: Panayotis Papapostolou: "Re: Populate Access table with Oracle data - how?"
- In reply to: Duncan: "Re: Connecting to a FoxPro DBF file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
