Convert Paradox files to Access

[Guest]

I am thinking about converting all my Corel files to Microsoft Office 2003
Professional version. Is it possible to convert my database files from
Paradox to Access? If so, is it very difficult? Creating new tables and
re-entering all data is not an option.

 

[Andi Mayer]

I am thinking about converting all my Corel files to Microsoft Office 2003
Professional version. Is it possible to convert my database files from
Paradox to Access? If so, is it very difficult? Creating new tables and
re-entering all data is not an option.

If you talk obout tables than it's easy.
Import them

Than look if all the fields are really there, if not (memo!!) than
.......


If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

 

[John Vinson]

I am thinking about converting all my Corel files to Microsoft Office 2003
Professional version. Is it possible to convert my database files from
Paradox to Access? If so, is it very difficult? Creating new tables and
re-entering all data is not an option.

It's doable, but it's not going to be fun. :-{(

You can Import the data in the tables. All the Paradox user interface
features will have to be not only redone, but reTHOUGHT - Access Forms
are *very* different in structure and design from Paradox forms.

You will probably also need to give some careful thought to
normalizing your table structure. Paradox is less fully relational
than Access, and it's routine to have "lookup" fields and calculated
fields in Paradox tables; neither type of field is appropriate in
Access. Instead you'ld store the base data in Tables and use Queries
to do the links and the calculation.

All the caveats out of the way - I'd strongly recommend it. Access is
(IME) a stronger and easier-to-use programming and development
environment than Paradox.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps