Nice Avitar! My Mom got to meet him… she said he was just a nutty as people thought he was…
Specifically, I need a way to import external data. Currently I have to manually create the table, and then link to the table using MS Access’ ODBC connection. Then I have to push the data into the table.
If I’m pulling data together from sources already in my oracle db’s, I can just write a make table query and I’m done. But external sources of data, say from a vendor, I have to use third party software to pull in and clean the data, then push it to Oracle via Access, before I can run anything against in in SQL Nav. Its a little frustrating.
I describe Access to newbies as a 4cylinder engine. Oracle is a Supercharged V8 350. The problem is just getting the data TO the db.
any wisdom that can be imparted is greatly appreciated. Oh… and keep in mind when wracking your neurons, the department that runs our Oracle servers is very stingy about letting me play in their sandbox. The Oracle gods don’t play fair, lets put it that way. They’ve given me permission to tinker since I appear to have some knowledge in the area. If they knew exactly how much I know, they’d fill in the rabbit hole, if you catch my drift… LOL…