|
Home > Archive > dBASE Questions and Answers > August 2005 > FoxPro Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jim Davidson 2005-06-22, 11:23 am |
| Our client would like to send us a FoxPro database with several memo fields. Is it possible to import the database into dBASE Plus v2.02 without disrupting the memo fields? If so, how would this be accomplished? If not, what are my options?
Thank you,
Jim Davidson
| |
| Ken Mayer [dBVIPS] 2005-06-22, 1:24 pm |
| Jim Davidson wrote:
> Our client would like to send us a FoxPro database with several memo fields. Is it possible to import the database into dBASE Plus v2.02 without disrupting the memo fields? If so, how would this be accomplished? If not, what are my options?
My understanding is that you should be able to read it, with the native
FoxPro driver. However, I would not suggest you modify it, as that may
cause problems with the .CDX file. The support for those is not good.
My suggestion would be to have them send a test table with a few rows,
and try reading it. If you can read it, you could, perhaps, copy the
data to a dBASE .DBF and work with it ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Jim Davidson 2005-06-23, 11:23 am |
| Ken,
I have tried to open the table as a normal table but receive the message "Database Engine Error: Corrupt table/index header." Is there a different way to open the table?
Thank you,
Jim Davidson
Ken Mayer [dBVIPS] Wrote:
> Jim Davidson wrote:
>
> My understanding is that you should be able to read it, with the native
> FoxPro driver. However, I would not suggest you modify it, as that may
> cause problems with the .CDX file. The support for those is not good.
>
> My suggestion would be to have them send a test table with a few rows,
> and try reading it. If you can read it, you could, perhaps, copy the
> data to a dBASE .DBF and work with it ...
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
| Ken Mayer [dBVIPS] 2005-06-23, 11:23 am |
| Jim Davidson wrote:
> Ken,
>
> I have tried to open the table as a normal table but receive the message "Database Engine Error: Corrupt table/index header." Is there a different way to open the table?
Which version of Foxpro? It may be a version that was done after the
driver the BDE uses, in which case it may not be possible to open it via
the BDE ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Roland Wingerter 2005-06-23, 11:23 am |
| Jim Davidson wrote:
>
> I have tried to open the table as a normal table but receive the
> message "Database Engine Error: Corrupt table/index header." Is
> there a different way to open the table?
-------
You need to set up a BDE Alias first. If it is a recent version of Foxpro
you need a Foxpro ODBC driver, which can be downloaded from the MS website.
Roland
| |
| Eric Logan 2005-06-23, 8:24 pm |
|
[color=darkred]
> "Roland Wingerter" wrote
> You need to set up a BDE Alias first. If it is a recent version of Foxpro
> you need a Foxpro ODBC driver, which can be downloaded from the MS
website.
I use some FoxPro version 6.5 files that can't be opened in dBase with the
native FoxPro 5.0 driver. I can open those files through a ODBC-BDE
connection. The memo fields work properly. A method for setting up the
connection is 1) In the ODBC Data Source Administrator, add an ODBC System
DSN with the 'Microsoft Visual FoxPro Driver'. 2) Configure it. The database
type probably should be 'Free Table directory'.(Unless you have set up a
FoxPro database : .DBC) The path is the directory path to the FoxPro dbfs.
3) Once ODBC is set up go to the BDE. The new ODBC database should
automatically be in the list of databases. Open it, assign a language
driver, and save changes. You should then be able to open the FoxPro tables
in dBase, via the BDE database.
Hope this helps
Eric Logan
| |
| eric wu 2005-08-18, 8:24 pm |
| I can open FoxPro tables by using ODBC driver
but can not write data into a table that has a MEMO field
dBASE does not allow to write on the FoxPro table ( the one w/ MEMO ) or
there's some setting need to be done ?
> I use some FoxPro version 6.5 files that can't be opened in dBase with the
> native FoxPro 5.0 driver. I can open those files through a ODBC-BDE
> connection. The memo fields work properly. A method for setting up the
> connection is 1) In the ODBC Data Source Administrator, add an ODBC System
> DSN with the 'Microsoft Visual FoxPro Driver'. 2) Configure it. The
database
> type probably should be 'Free Table directory'.(Unless you have set up a
> FoxPro database : .DBC) The path is the directory path to the FoxPro dbfs.
> 3) Once ODBC is set up go to the BDE. The new ODBC database should
> automatically be in the list of databases. Open it, assign a language
> driver, and save changes. You should then be able to open the FoxPro
tables
> in dBase, via the BDE database.
> Hope this helps
> Eric Logan
>
>
|
|
|
|
|