Converting dBase III Plus *.prg file to Access query

[Wayne]

Where can I find tips for converting an old dBase III Plus
*.prg file into a query. I'm looking for info on
translating dBase statements into Access query
statements. I'll then paste translated staements into SQL
view and be done. Thanks in advance for any help.
Wayne

 

[Immanuel Sibero]

Hi Wayne,


You'd be better off rewriting prg programs in Access (i.e. escpecially those
developed in dBaseIIIPlus).

The whole programming philosophy is very different in dBaseIIIPlus:
- dBaseIIIPlus is more record-by-record processing as opposed to a set
oriented processing in Access.
- the user interface is vastly different, there so many enhancement in the
GUI in Access that you would want to rewrite the application anyway.
- a prg file is NOT equivalent to a query in Access. If anything, a prg to
dBase is a vba module to Access. No known conversion tool to my knowledge.

About the only thing in dBaseIIIPlus application that can be ported easily
to Access is the data (ie. tables).


HTH,
Immanuel Sibero