how to import queries from Paradox to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am converting from Paradox to Access and all of the tables have been
successfully transfered using "Import" but now I want to copy/import
everything else...file by file. I am now on queries. The "Import" command
will only transfer tables and I do not have an option to transfer other kinds
of files like queries, forms and reports. I do not know where to go from
here. Please inform me on the correct procedure to convert from Paradox to
Access.

Thank you....
 
If memory serves (and this was 6 years ago, circa Y2K conversion) Paradox
Forms and Reports won't convert. You'll have to rebuild them by hand in
Access.

You might be able to copy the SQL of the Paradox queries into a text file
and then paste that SQL into new Access queries, but I don't remember how
much manual conversion of that SQL will be necessary. The db I converted was
a little light on queries before conversion.

HTH,
 
Back
Top