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

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




"Wayne" <anonymous@discussions.microsoft.com> wrote in message
news:004a01c3d162$396b4f40$a601280a@phx.gbl...
> 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