Reading printer files with Access
Posted on 2014-04-24
This is a blue sky type question. No data, just looking at future planning.
My old SW company was bought out by our new SW company a a while back. We had access to the source code and data so it was relatively easy us to use Access to build conversion routines from the old SW to the new SW. Our conversion team was so good that we broke records for conversions and made the new company expand their data services team. They were struggling to keep up with us and still do the other conversions. Well we're now getting to the end of our SW customers.
That leaves me in the thinking ahead mode. I want to see if I can come up with a way to convert other customer's data from "foreign" competitors. Some of them are on-site server/client type apps. Others are a website types. The server/client sort of worry me, but if I can find a way to read the DB (legally) I can probably build a conversion system.
The worst idea that may work is have the clients dump the files to PCL/PRN/PDF or other printer file types and then read those files.
So what I'm looking for is some type of Access/VBA routine that will allow me to read that type of file and extract data. I can deal with the "wrapping" of files and finding text. It's a matter of how to read that data.
Any suggestions will be appreciated.