troubleshooting Question

How to capture data from a legacy windows application / database

Avatar of eCareMD
eCareMD asked on
Databases
2 Comments1 Solution314 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros