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

"Johnson Shine" wrote:

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!