Board index » delphi » Converting a paradox table to a dbase table

joeldi...@my-dejanews.com

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Converting a paradox table to a dbase table

Can anyone help me in how to convert a .db (paradox) table to a .dbf (dbase)
table. I tried opening up the old table and changing the tabletype to ttdbase,
but I get a lot of different error messages. Is there an easy way to do this?

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

 
JefSumme

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Converting a paradox table to a dbase table


Quote
In article <7dgndn$9i...@nnrp1.dejanews.com>, joeldi...@my-dejanews.com writes:
>Can anyone help me in how to convert a .db (paradox) table to a .dbf (dbase)
>table. I tried opening up the old table and changing the tabletype to
>ttdbase,
>but I get a lot of different error messages. Is there an easy way to do this?

The way I'd do it is this:
1. Using the database desktop, create a dBase table with the equivalent
structure to your Paradox table.
2. Use an Insert query in the database desktop to insert the data from the
Paradox table into your new dBase table.

Should take no more than 10 minutes to do, depending on the complexity of the
table structure and number of records.

/js

Steve Koters

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Converting a paradox table to a dbase table


Quote
On Fri, 26 Mar 1999 19:33:12 GMT, joeldi...@my-dejanews.com wrote:
>Can anyone help me in how to convert a .db (paradox) table to a .dbf (dbase)
>table. I tried opening up the old table and changing the tabletype to ttdbase,
>but I get a lot of different error messages. Is there an easy way to do this?

You cannot just convert a table file from one type to another. You can copy
the structure and data from a file of one type to a new file of another
type.

One way to do this programmatically would be to use a TBatchmove component
to copy the table from the old Paradox table to a new dBASE table.

Another way would be to use the BDE API function DbiCopyTable.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "Like a camel, I can go without a drink for
Technical Publications         seven days--and have on several horrible
INPRISE Corporation            occasions."
http://www.borland.com/delphi                                 -- Herb Caen

Richard Cart

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Converting a paradox table to a dbase table


Quote
JefSummers (jefsumm...@aol.com) wrote:

: >Can anyone help me in how to convert a .db (paradox) table to a .dbf (dbase)
: >table?

: 1. Using the database desktop, create a dBase table with the equivalent
: structure to your Paradox table.
: 2. Use an Insert query in the database desktop to insert the data from the
: Paradox table into your new dBase table.

: Should take no more than 10 minutes to do, depending on the complexity of the
: table structure and number of records.

Well, that's the hard way.  In Database Desktop, just do
Table-Copy, and give the destination table a .dbf extension.
--
============================================================
Rick Carter   carte...@email.uc.edu   rcar...@tso.cin.ix.net
============================================================

joeldi..

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Converting a paradox table to a dbase table


Thanks. I didn't make myself clear in the first message. I want to do this at
run-time and not using the BDE. I will try your suggestions and let you know
how it turns out.

In article <36fd02fa.19487471@newslist>,

Quote
  skoter...@NOSPAMinprise.com wrote:
> On Fri, 26 Mar 1999 19:33:12 GMT, joeldi...@my-dejanews.com wrote:

> >Can anyone help me in how to convert a .db (paradox) table to a .dbf (dbase)
> >table. I tried opening up the old table and changing the tabletype to
ttdbase,
> >but I get a lot of different error messages. Is there an easy way to do this?

> You cannot just convert a table file from one type to another. You can copy
> the structure and data from a file of one type to a new file of another
> type.

> One way to do this programmatically would be to use a TBatchmove component
> to copy the table from the old Paradox table to a new dBASE table.

> Another way would be to use the BDE API function DbiCopyTable.

> //////////////////////////////////////////////////////////////////////////
> Steve Koterski                 "Like a camel, I can go without a drink for
> Technical Publications         seven days--and have on several horrible
> INPRISE Corporation            occasions."
> http://www.borland.com/delphi                                 -- Herb Caen

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

Other Threads

1. Which Program can convert a F&A-Table to a Paradox or DBase-Table

2. convert dbase for windows tables to dbase IV

3. Copying a paradox table to a dBase IV-Table

4. dbase tables vs paradox tables

5. Paradox Tables vs. dBASE IV Tables

6. converting dataease tables to paradox tables?

7. Q: Converting Paradox table to MS SQL table

8. CONVERTING FOXPRO TABLE TO PARADOX TABLE AT RUNTIME

9. Convert Paradox SQL result cursor to Paradox table

10. Convert Paradox 5 to Paradox 7 tables