I am tasked here at work with coming up with a way for folks using MS Access to create (or at least write to) tables in an Oracle database. The acronym ODBC (Open Database Connectivity) has been thrown around, but no one here really knows how it works.
I have all the Oracle privileges I need … just need to get a basic understanding of what ODBC can do. Can true-blue DDL be passed to a Oracle DB from inside of Access? The idea is to take tables that exist in an Access DB and have them built in Oracle. I know several “long” ways to do this, but we are trying to do it in the most efficient method possible.
Another hang-up: I have little knowledge of Visual Basic (though I can sort out what a VB script is doing, most of the time).