Excel VBA against Oracle

  • Thread starter Thread starter Johnson Shine
  • Start date Start date
J

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!
 
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
 
Excel can also attach to the Oracle database using SQL.

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