how to migrate one database to another ?

[asiamisia]

I was thinking of writing a VB script to transefer data from one access database to another. the problem is that the structures are diffrent - some data matches the other and some not (ex. In source table I should concate two firlds to get the destiny field, some fields would be left..)

How to write such a script ? can anyone show me an example or maybe there is a software I could use - witch would transfer fields excactly as I wish ?

 

[Mile-O]

Maybe you should create a further table that's identical to that in the other database. With the first database you can run and APPEND query that fixes your data to the specification you want and append it to the new table. Then APPEND the new table to the other database.