I would be grateful if someone could advise me on purchasing a program to pull data out from our Oracle database. This database has been used for several years We have been using Developer 97 to pull data into Access tables with the Windows 2000 operating system. We have recently purchased a new computer which uses Windows XP and will be grateful if you could advise on a suitable program to use with this.
In other words, there is an application in Access? If so, how come data is stored in Oracle and not in Access? How does data come to Oracle? Would it be possible to redirect that path directly into Access instead?
It's just the fact that there's always one step too much here, and I'm just trying to figure out if it could be avoided.
I've never heard of "Developer 97", but I guess you tried to install it on your new computer but it doesn't work. Did you try it?
Unfortunatelly, I don't know any other tool, but you might use ODBC and access Oracle database directly from Access (or Excel). Here is a link to the page which will show you how to establish a connection and pull data out of Oracle database. I hope it'll be helpful enough for you: Accessing Oracle via Access and Excel