Excel VBA against Oracle

[Johnson Shine]

Hi, Would anyone help me answer this question? Can Excel VBA get data in
Oracle DB server? How can we do that? As I know, Excel VBA code is always
only able to get real-data which is from Access DB. Would appreciate it very
much!

 

[Guest]

As long as you know the table name and layout of the Oracle database you want
to query then it's as simple as connecting to the database using Excel VB
code and importing the columns of data you require. If your happy to wait
until tomorrow until I'm back at work I'll mail you some sample code that you
should be able to adapt to do what you require.

Mike

 

[Ildhund]

You might profit from taking a look at

http://www.oraxcel.com/projects/sqlxl/index.htm

SQLXL makes child's play of interacting with Oracle DBs.

 

[Guest]

Excel can also attach to the Oracle database using SQL.

Try the menu Data, Get External Data and New Database Query.