dBase III to MS Access migration

[knuckle05]

Hi All,

I'm looking to convert a DOS based dBase III app to a form-driven MS Access application.

I doubt there is anything that could assist me in conversion with the UI, but is there anything to assist in migrating at least the database?

Pls advise...

Thx!

 

[tviman]

You can use the database as is but I don't recommend it. The DBF format makes it difficult to utilize the features that make Access what ti is. Your best bet is to bite the bullet and re-write your application.

There's always a better way. The fun is trying to find it!

 

[1oldfoxman]

Access has an import funtion to do what you wish.

File/Get External Data/Import. Change the search file extension to *.dbf (choose dBaseIII from the drop down menu). I don't have a dBaseIII file to test on at the moment, but seems like I've been successful at this in the past. (btw, I'm looking at MS Access'97, so on newer versions, the Import utility might be in a different menu location.)

hth
dennis

 

[tviman]

The import function just works with the data files. It won't do anything for your .PRG, .SCN, .FMT, or .EXE files. You're going to have to build all those from the ground up.

There's always a better way. The fun is trying to find it!