troubleshooting Question

vb6 and Access 95 mdb upgrade to and accdb

Avatar of RekhaShah
RekhaShah asked on
DatabasesMicrosoft AccessVisual Basic ClassicVisual Basic.NET
40 Comments1 Solution295 ViewsLast Modified:
Hi Experts
I am working on a 20+year old legacy system written in vb6 and uses Access 95 database. I am going to rewrite this application using Visual Studio(latest) and latest Access Database.
I am trying to find a way to upgrade my databases. we have an mdb file for each job. so conversion has to be done pragmatically. I was thinking of writing up a utility that exports mdb table to .csv file. and Read that .csv file into the latest Access database.. Am i on the right path? if so, how would i go about it? I am thinking o sticking to to reduce the learning curve. I will  highly appreciate any advice/suggestion.
Thank you
Join our community to see this answer!
Unlock 1 Answer and 40 Comments.
Start Free Trial
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 40 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