eCareMD
asked on
How to capture data from a legacy windows application / database
Hi Experts,
I need to find software or something that will allow me to capture my customer records from an older windows application which we are discontinuing the use of. We've decided to upgrade to a new software app that will need to be populated with over 100,000 customer records from our old system. The old application uses a database with a file extension of .MDB and I am assuming this is probably a Microsoft database since we have no other (like MySQL or Oracle) DB installed.
I have heard the term "Screen scraping" and grasp the concept of it, however, I need to find a scraper that can be configured to scrape from a windows app, not hooked into Internet Exploder or be web based.
The instance of the windows app is local, and doesn't rely on network services to do anything, including fetching from a DB server.
Preferrably, the software will allow the captured data to be written or dumped into a CSV or similar for use in Excel. Then the excel document can be edited and imported by the new application. Time is of the essence due to such a high volume of records and in light of the fact that we need to have the new system live by March 1.
Any help is much appreciated.
I need to find software or something that will allow me to capture my customer records from an older windows application which we are discontinuing the use of. We've decided to upgrade to a new software app that will need to be populated with over 100,000 customer records from our old system. The old application uses a database with a file extension of .MDB and I am assuming this is probably a Microsoft database since we have no other (like MySQL or Oracle) DB installed.
I have heard the term "Screen scraping" and grasp the concept of it, however, I need to find a scraper that can be configured to scrape from a windows app, not hooked into Internet Exploder or be web based.
The instance of the windows app is local, and doesn't rely on network services to do anything, including fetching from a DB server.
Preferrably, the software will allow the captured data to be written or dumped into a CSV or similar for use in Excel. Then the excel document can be edited and imported by the new application. Time is of the essence due to such a high volume of records and in light of the fact that we need to have the new system live by March 1.
Any help is much appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I didn't have Access in my standard Office complement, so I went and found a util that is freeware(!) and will open / read / edit the records beautifully!! The util is called "MDB Viewer Plus" so if anyone wants it, hit google up for it.
Thanks for the fast response and accurate solution, Nick.