[RESOLVED] Transfer data between two access databases

[CherryPickle]

Hi, All

I am in the process in developing a new version of my software. I have changed my design of my database slightly (added a few new tables and new fields to existing tables). The issue is that my users have user data in the old Db that I would like to transfer to the new Db. Both Db's are access 2003. Because my software is distributed over a wide geographical are it would not be possible to do this manually

I have appended data between two different tables in a single Db, but not between two separate Db's.

Can someone please assist, sample code would be appreciated
I have searched the threads but have no success.

Thanx

[Hack]

In a case like this my suggestion would be to have your clients zip their existing database and FTP it to you for you to upgrade.

After which, of course, you would be able to test your app against each clients database and visually verify everything was OK.

At that point, you could FTP it back to them.

[CherryPickle]

The data transfer is really not much. My users are not even at moderate level of computer literacy. I have a small dataset that I request them to e-mail me on a regular basis, but most of them do not even get this right. I had to automate the process. I also have about 150 users.

I really need to solve this issue in code.

[jggtz]

I have appended data between two different tables in a single Db, but not between two separate Db's.

Open 2 connections (one for every mdb)

I had to automate the process.

Read about ADOX
You could send them a small app that modify the mdb & tables structure

[CherryPickle]

Hi, I found a solution to my problem. I anyone is battling with a similar issue try the link below. The code is in C#, but I managed to convert it.

Not sure if this is the best solution, but it works well for me.

Thanxs for help offered.


http://69.10.233.10/KB/database/Gene...leDataFcn.aspx