Re: import data from FoxPro database (ISIS)
- From: "Cindy Winegarden" <cindy@xxxxxxxxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 10:01:31 -0400
Hi Amanda,
Yes, you've got Visual FoxPro files. The DBC table is a "database container"
where things like stored procedures and view definitions are stored. The DCX
is the index for the DBC table and the DCT is the contents of any memo
fields. In addition to the DBC you should have DBFs which are the actual
FoxPro tables; CDX is the optional indexand FPT is the optional memo,
although you need to have both present since the table knows whether it has
them or not.
Over time new data features have been added to FoxPro tables, making them to
be no longer compatible with Jet. However, you can probably use the FoxPro
and Visual Foxpro ODBC driver to link the tables to your MDB. However, with
VFP7 and above, even more data features were added making the tables only
accessible via OLE DB and ADO. However, tables created with VFP7 and above
that don't have the new features are still compatible with ODBC. If you use
ODBC, the connection string should point to the DBC itself (if there is no
DBC present you would use the "free" table option and point only to the
directory where the DBFs are stored. A typical OLE DB connection string is
"Provider=VFPOLEDB.1;Data Source=MyPath\MyDBC.dbc;" or for free tables:
"Provider=VFPOLEDB.1;Data Source=MyPath;"
The ODBC driver and OLE DB data provider are downloadable from the links
below my signature. The OLE DB data provider works with all versions of
FoxPro tables and is totally backward compatible.
With OLE DB your SQL statement should refer to the table itself such as
"Select * From MyTable" without the DBF extension and without referencing
the DBC.
--
Cindy Winegarden
cindy@xxxxxxxxxxxxxxxxxxx
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"Amanda Byrne" <AmandaByrne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F36387C-31BE-4A2C-BBCC-23DA67A0CA5C@xxxxxxxxxxxxxxxx
The files typically have .dbc, .dct, .dcx extensions. The files that
contain the data I need are .dbf. I have no idea what version of FoxPro
this
might be- but have had no luck trying to import the dbf files....
.
- Follow-Ups:
- Re: import data from FoxPro database (ISIS)
- From: Amanda Byrne
- Re: import data from FoxPro database (ISIS)
- Prev by Date: During Import-force single data field from text to numeric - Help?!
- Next by Date: Re: During Import-force single data field from text to numeric - Help?!
- Previous by thread: During Import-force single data field from text to numeric - Help?!
- Next by thread: Re: import data from FoxPro database (ISIS)
- Index(es):
Relevant Pages
|
