how to import queries from Paradox to Access

W

WalkerIssue

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....
 
G

George Nicholson

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top