Converting PFS to Access
Posted on 2013-01-16
So I've managed to stumble upon a fun one.
A client is using a program named PFS, which was written in 1984 to store their data. A recent upgrade to Windows 7 64-bit has made it apparent to them that they need to upgrade.
It would be awesome to port the data over to Access instead of having to manually move the data over (there's a lot). After some furious Googling, the best I've seen is that PFS v2.0 will export to dbase III, and from there I can covert it to Access. The biggest issue is that this appears to be PFS v1.0, which means no export function.
I am able to view some of the data if I open the database flat file in Notepad++, however there is no easy way to parse the data as far as I can tell.
So DB gurus. Let me know if you can think of anything that will help get the data converted. Thanks a ton!