.prg to VBA conversion

[jey2]

I have a large number of dBase 4 and 5 .prg files that I need to convert to VBA modules in Access or Excel. The tables convert nicely, but is there any help for conversion of the data processing?

Thanx in advance.

 

[kennedymr2]

Jey2...

I have done a lot of conversion work from .prg to access.

Have not found any auto conversion programs around that are really any good.

Gave up in the end, and just manually did it !!!!!

I usually paste the .prg code into the VBA code area, and just edit it to run under access..
The code is very similiar in a lot of areas, but when dealing with the database area, it will involve creating quite a few access queries for the actual database commands.

I have found that a very big section of the .prg code can be totally replaced with a clever access queries.
I converted one large .prg project, and probably ended up with only about 5% of the volume of original code.

Good luck with your conversion..

Regards Kennedymr2

 

[kennedymr2]

Jey2...

Thought i might expand a bit on my 1st reply.

Basically you can only automatically convert the dbase tables to access.

Other tha that you really have to start from scratch
ie. create new forms, reports etc.

Most of the code is best converted by using queries, which are pretty smart in access.
You will still end up with a certain amount of code.

You are best to become very good at creating queries, this is the trick in access.

Regards Kennedymr2