|
Re: Excel + VBA + odbc + ORACLE [message #83431 is a reply to message #83425] |
Tue, 07 October 2003 06:11 |
dc
Messages: 6 Registered: May 2002
|
Junior Member |
|
|
Depending on how much manipulation of the data you want to do, you can either use the "Get External Data" wizard under the "Data" menu in Excel or open up the "Visual Basic Editor" from the Tools -> Macros menu and code your connection string and SQL in a module there.
|
|
|
Re: Excel + VBA + odbc + ORACLE [message #84020 is a reply to message #83431] |
Mon, 19 January 2004 02:48 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Further to that, I would suggest that you start recording a macro, then use the get external data wizard. You can then open up the vb editor & copy & paste the code into your script.
|
|
|