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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick UpsonPrincipal Operations EngineerCommented:
why not export the data into csv using access (which I think is for .mdb files). try it and see

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
eCareMDAuthor Commented:

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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.