Accessing ORACLE DB w/ADO

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

When I access an Oracle DB using ACCESS, I am able to read from the table
and return data. But when I use ADO from within Excel VBA, it gives me thje
ORA-00942 error whicj means Table or View cannot be found. Anyone encounter
this or knows what it means or why this is happening with Excel ADO?
 
Nothing wrong with Excel in accessing Ora tables, suggest you post your code
for a once over in here.
Cheers
N
 

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

Similar Threads

Problem wqith connection to Oracle 1
Programs hangs when deleting elements with ADO DB and Oracle 2
Manipulating MS Access records with excel VBA + ADO 7
ADO - accessing oracle 3
How to access date from Oracle Databace to Excel 1
Query Oracle from Excel 7
ADO-Trapping Oracle Errors 1
[oracle][odbc][ora]ORA-00942: table or view does not exist (#942) 1

Back
Top