Convert Paradox database to MS Access

[Merlin]

I have several Paradox tables without encryption, and I want to convert
them to MS Access/Excel. I tried the Import feature of MS Access, but
it reports me about invalid file format...

I searched for appropriate tools, but I found only "Paradox Viewer"
from Scalabium Software, that converts only first 100 records (though,
does it perfectly) and requires purchasing for further operations.

I'm sure there should be an easy (and free :-) way to perform such an
easy operation as converting Paradox table into Access/Excel/Text. Can
you advice something?

Thanks in advance!

[Steven Green]

usually, it's this simple:

a) File / Open / pick a paradox table
b) Access asks you to insert the Office Cd to install the paradox drivers

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

[Ed Nash]

Merlin wrote:

I have never had a problem importing or linking Paradox tables in
Access, since Office 2000 on up. Make sure you right-click Tables in
Access and choose Import... and Files of Type: *.db This should be
available with a good install of MS Office.

Other workarounds:
(1) In Paradox, copy the tables to a .dbf format. This is real simple:
right-click the table, select copy, and in the dialog box that appears,
put an 'f' immediately after the .db in the file name, then press OK.

(2) Use Excel to read the Paradox table and then have Access read the
Excel. Don't bother with File | Open... Instead, use Data | Import
External Data | Import Data... | Files of Type: Paradox (*.db)

[Merlin]

I have Office 2003. I tried to use Excel in this way, but in the end it
says "Unexpected error from external database driver (11265)". Should I
configure anything in order to use this function?

Post by Ed Nash
I have never had a problem importing or linking Paradox tables in
Access, since Office 2000 on up. Make sure you right-click Tables in
Access and choose Import... and Files of Type: *.db This should be
available with a good install of MS Office.
right-click the table, select copy, and in the dialog box that appears,
put an 'f' immediately after the .db in the file name, then press OK.
(2) Use Excel to read the Paradox table and then have Access read the
Excel. Don't bother with File | Open... Instead, use Data | Import
External Data | Import Data... | Files of Type: Paradox (*.db)

[Ed Nash]

Post by Merlin
I have Office 2003. I tried to use Excel in this way, but in the end it
says "Unexpected error from external database driver (11265)". Should I
configure anything in order to use this function?

I have invoked errors like this before and seem to recall it had
something to do with the Paradox table (or maybe even just having
Paradox open in the directory where the table lived) being open or in
use. Also, I googled your error message and found this link that may be
helpful.

http://www.ureader.com/message/1385195.aspx

[Sundial Services]

Post by Merlin
I have several Paradox tables without encryption, and I want to convert
them to MS Access/Excel. I tried the Import feature of MS Access, but
it reports me about invalid file format...
I searched for appropriate tools, but I found only "Paradox Viewer"
from Scalabium Software, that converts only first 100 records (though,
does it perfectly) and requires purchasing for further operations.
I'm sure there should be an easy (and free :-) way to perform such an
easy operation as converting Paradox table into Access/Excel/Text. Can
you advice something?

Buy a copy of Paradox. This gets you the "real" Paradox drivers, which use
the BDE code. Without it, Access might use some ancient and buggy code
that was based on old third-party vendor stuff from people who didn't do
their homework.

With those drivers, connections to Paradox tables from within Access work
just fine. You can attach to them, or you can import them, as you wish.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com

[Sven Pran]

Post by Merlin
I have several Paradox tables without encryption, and I want to convert
them to MS Access/Excel. I tried the Import feature of MS Access, but
it reports me about invalid file format...
I searched for appropriate tools, but I found only "Paradox Viewer"
from Scalabium Software, that converts only first 100 records (though,
does it perfectly) and requires purchasing for further operations.
I'm sure there should be an easy (and free :-) way to perform such an
easy operation as converting Paradox table into Access/Excel/Text. Can
you advice something?
Thanks in advance!

You have had some answers already, but be aware that Paradox
accepts "null" values in record fields where this is illegal in Access.

This caused errors when I converted some Paradox tables to
Access tables, a process that otherwise went without problems
on my computer where both Paradox and Access are installed.

regards Sven