PDA

View Full Version : Is it possible to migrate data using visual basic in excel with other systems?



wedd
01-16-2012, 04:34 AM
Hi experts,

I've been trying to migrate data from ms excel 2010 into sql, sas,oracle, internal bespoke systems, 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 excel...

Thanks for your contributions!!:friends:

Bob Phillips
01-16-2012, 05:47 AM
Depends what you mean by migrating, but automation between other systems and Excel is usually simple. ADO provides a connection layer that facilitates such communication.

Why not ask your specific questions here?