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?
RE: write data to a closed file on network drive ... I don't know much about the technical specs of ADO,... works just for Excel too, ...Sub RS2WS ... Microsoft Active X Data Objects Recordset 2.8 Library ... (microsoft.public.excel.programming)
Excel file bloat using ADO ... I have modified a routine based on the following WebPage that uses ADO... to add data to closed Excel files.... How do I update an Excel spreadsheet using ADO? ... Apparently, this is a problem with Access files, given the number of ... (microsoft.public.excel.programming)
Re: Excel file bloat using ADO ... Rather than use a recordset, instead use INSERT INTO and UPDATE sql ... > I have modified a routine based on the following WebPage that uses ADO... > How do I update an Excel spreadsheet using ADO? ... > Apparently, this is a problem with Access files, given the number of ... (microsoft.public.excel.programming)
Re: SQL incorporation with Excel ...Excel 2002 VBA by Bullen, Green, Bovey and Rosenberg has a fairly good ... Set a reference to ADO 2.7 in your vb project. ...connection string to find the correct way to connect. ... Our accounting system uses an SQL... (microsoft.public.excel.programming)
Re: DB question ... > Sybase, Oracle, Excel etc. ... I want to write a generic COM method using ADO by ... > which I can retrive the columns for a particur table for a selected DSN. ... (microsoft.public.vb.database.ado)
