Converting old Paradox database

[gjbl...@gmail.com]

Hi,

I am trying to access several old paradox databases. I am not sure
what in what version of Paradox they were created (they contain public
government data from the early 1990s). Is there any easy way to
convert them or import them into MS Access or Excel? I've tried using
the Access import function, but every time I do so, I get an error
message saying "Reserved error (-5016); there is no message for this
error".

I should say at the outset that I am not a software developer. If
this isn't the appropriate place to post this kind of question, my
apologies in advance.

Thanks.

Greg

[Liz McGuire]

Greg,

How do you know they're Paradox files? Lots of file formats use .DB as
an extension. If in addition to seeing .db, you see one of the
extensions listed below, there's a better chance the files are Paradox:
.px
.mb
.val
.tv
.fam
.x0?
.y0?
.xg?
.yg?

If none of these file extensions are used, there's a chance the files
aren't Paradox at all.

If they are Paradox, the easiest way to convert them into something else
is to use Paradox. You wouldn't need to be a programmer - just File >
Export and use the wizard.

Liz

[Steven Green]

by default, Excel and Access need drivers installed to work with paradox
tables, that you don't have readily available.. as Liz said, a simple export
from paradox itself is easiest.. if you don't have paradox, I sell old
versions on my web site.. but first, you need to be sure that they ARE
paradox tables..

--

Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage and Custom Lego Creations

Diamond Software Group
- Paradox Sales and Support

Diamond Sports Gems
- Sports Memorabilia and Trading Cards
"Liz McGuire" <l...@paradoxcommunity.com> wrote in message
news:49b08066$1...@pnews.thedbcommunity.com...

[gjbliegel]

> > gjblie...@gmail.com wrote:
> >> Hi,
>
> >> I am trying to access several old paradox databases.  I am not sure
> >> what in what version of Paradox they were created (they contain public
> >> government data from the early 1990s).  Is there any easy way to
> >> convert them or import them into MS Access or Excel? I've tried using
> >> the Access import function, but every time I do so, I get an error
> >> message saying "Reserved error (-5016); there is no message for this
> >> error".
>
> >> I should say at the outset that I am not a software developer.  If
> >> this isn't the appropriate place to post this kind of question, my
> >> apologies in advance.
>
> >> Thanks.
>
> >> Greg

Thanks to you both, Liz and Steven.

The files have the following extensions:
.db
.mb
.px
.tv
.val
.x0d
.x02
.x03...
.y02...
.yG0...

I do not have paradox. Any recommendations on which version to
download? I assume later versions can also handle earlier paradox
data? Thanks!

[Liz McGuire]

gjbliegel wrote:
>
> The files have the following extensions:

> ..db
> ..mb
> ..px
> ..tv
> ..val
> ..x0d
> ..x02
> ..x03...
> ..y02...
> ..yG0...

That's Paradox all right.

> I do not have paradox. Any recommendations on which version to
> download? I assume later versions can also handle earlier paradox
> data? Thanks!

Paradox 7 or later can open all Paradox table levels (the last change to
the table format was in p7, so that or anything more recent will work).
Check out whatever Steve has to offer.

Alternately, you could look for Paradox database drivers for Excel or
Access. I thought Microsoft had one, in which case, that ought to be
good enough for conversion (unless it needs the BDE or something). I've
never converted Paradox files without Paradox...

Liz

[Steven Green]

> Alternately, you could look for Paradox database drivers for Excel or
> Access. I thought Microsoft had one

in Access.. File, Open, change the type to db, pick a paradox table.. Access
should prompt you for the Office installation CD for the drivers, if you
have it.. but I think that'll be level 5 drivers, and that could be a level
7 table.. if there's a memo/blob field (the mb file), that means it's at
least level 4..

--

Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage and Custom Lego Creations

Diamond Software Group
- Paradox Sales and Support

Diamond Sports Gems
- Sports Memorabilia and Trading Cards
"Liz McGuire" <l...@paradoxcommunity.com> wrote in message

news:49b2cc51$1...@pnews.thedbcommunity.com...