Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel VBA against Oracle

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!


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Excel VBA against Oracle

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!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel VBA against Oracle

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.

--
Noel

"Johnson Shine" wrote in message
...
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!


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default Excel VBA against Oracle

Excel can also attach to the Oracle database using SQL.

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

--
Richard


"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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
How can Oracle DB Stored procedure be called in MS Excel? Amol Excel Discussion (Misc queries) 1 January 7th 07 11:05 AM
How to get data from Oracle Database to Excel? David Willis New Users to Excel 1 March 31st 06 01:57 PM
How to update ORACLE query definition in Excel file Viks Links and Linking in Excel 0 January 6th 06 03:56 PM
Exporting Excel data to Oracle DB JBruxer Excel Discussion (Misc queries) 0 January 5th 06 08:40 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"