Fetch data from Oracle to Excel with Oracle ODBC driver using VBA

**clam** · 01-19-2005, 07:19 AM

Is there anybody know how to extract data from Oracle RDBMS to a Excel worksheet using VBA. Is it possible to create a db connection & a query in VBA code? Please advise. Thanks in advance.

clam

**Szegi Szabolcs** · 11-05-2022, 04:47 AM

Hi clam

have You received any reply? I also would be interested in the solution..
SzSz

**alansidman** · 11-05-2022, 11:39 AM

@Szegi Szabolcs

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Fetch data from Oracle to Excel with Oracle ODBC driver using VBA

LinkBack

Thread Tools

Display

Fetch data from Oracle to Excel with Oracle ODBC driver using VBA

Re: Fetch data from Oracle to Excel with Oracle ODBC driver using VBA

Re: Fetch data from Oracle to Excel with Oracle ODBC driver using VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions