connect to Oracle database

D

docchang

I have the name of the server, login name & pass, and tables I like to
work with.

How can I make query calls in VBA?

Thanks,

DC
 
R

Rod Gill

Hi,

Project VBA programming calls are better made in the project.developer
group. In the mean time, search the web for Oracle OLEDB connection string
to create a connection string, then use oledb calls to your Oracle db. You
need to make sure you have the very latest Oracle drivers installed. See
msdn.microsoft.com for sample oledb code to create a recordset and read
data.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top