Is it possible to migrate data using visual basic in access with other systems?

[wedd]

Hi experts,

I've been trying to migrate data from ms access 2010 into sql, sas etc. Are there any excllent books, websites or possibly personal experience you have of visual basic code to automate this process? I have limited knowledge doing migrations or "communicating" between different systems using vba code...so it will be very useful and interesting for me if you could share your expertise in this area to broading my knowledge of visual basic for access...


Thanks for your contributions:friends:

[HiTechCoach]

When you migrate data data from Aces that usually means you are converting away form Access to a new system.

I do lots of data migrations. Every migration is different. How to get data intot he new system depend a lot on the new systems capabilities. The best and simpliest is when you can create linked tables to the new system. Some will only import data using so tool in the new system.

[wedd]

Hi HiTechCoach, what would be the process to link tables from access to another database system such as sql, oracle etc? Will this process also involve programming with visual basic to communicate with the other database systems?

[HiTechCoach]

Hi HiTechCoach, what would be the process to link tables from access to another database system such as sql, oracle etc?


1) install the ODBC driver
2) Create a DSN
3) On the Access menu/ribbon create a linked table

This can usually be done manually in less than 5 minutes. No need to write an VBA code.




Will this process also involve programming with visual basic to communicate with the other database systems?

You code use VBA code to

1) install the ODBC driver
2) Create a DSN
3) create a linked table


Normally with a migration is is a one time thing. So it is probably ot worth the effort to try and write a lot of code to handle the this.

[wedd]

Thanks!

[HiTechCoach]

you're welcome.