Sephozzy
August 7th, 2001, 08:32 AM
Hey all,
While I'm experienced in Java and C++ I know very very little of databases or VB. For some my employer however asked me to write a tool in VB that converts data from some databases to another database. I have 2 different Acces databases (mdb files) that I use as input and I have to transport most of the data to a new Oracle db. Some data needs to be transformed or recalculated so I cannot simply export it (otherwise I wouldn't even have to write this program). I can reach the Oracle db through ODBC.
Being new to VB however I'm unsure about which approach I should use. Reading books and the MSDN library confused me even more with terminology like DAO, ADO, RDO... Can some of you guru's explain what would be a possible way to start on this project?
While I'm experienced in Java and C++ I know very very little of databases or VB. For some my employer however asked me to write a tool in VB that converts data from some databases to another database. I have 2 different Acces databases (mdb files) that I use as input and I have to transport most of the data to a new Oracle db. Some data needs to be transformed or recalculated so I cannot simply export it (otherwise I wouldn't even have to write this program). I can reach the Oracle db through ODBC.
Being new to VB however I'm unsure about which approach I should use. Reading books and the MSDN library confused me even more with terminology like DAO, ADO, RDO... Can some of you guru's explain what would be a possible way to start on this project?