Newbie : Oracle data to Access table.
- From: "General Fear" <richmarin@xxxxxxxxxxxxx>
- Date: 23 Jan 2006 15:32:30 -0800
I am using VB 6.0 and Access 2002.
I have a task where I need to do a select statement against an Oracle
table and put the data into an Access table. The SQL might look like :
" Insert Into MyAccessTable Select * From OracleTable "
Can I do this using ADO. If so, how ???
...
.
- Follow-Ups:
- Re: Newbie : Oracle data to Access table.
- From: Frank Hickman [MVP]
- Re: Newbie : Oracle data to Access table.
- Prev by Date: Re: Unexplained error updating or deleting record using ADO and VB6
- Next by Date: Re: Newbie : Oracle data to Access table.
- Previous by thread: Re: Unexplained error updating or deleting record using ADO and VB6
- Next by thread: Re: Newbie : Oracle data to Access table.
- Index(es):
Relevant Pages
- Re: Getting date/time fields from Oracle with ADO
... Yeah, when I 've used the SQL Plus Worksheet, the data was valid. ... I ran
this code against my oracle database and it worked fine: ... CREATE TABLE "GROUPDOC2"
NOT NULL, ... ado will report 135 for a date field in Oracle. ... (microsoft.public.vb.general.discussion) - Re: Oracle und MS-SQL
... > Wenn ich über SQL QueryAnalyzer oder EnterpriseManager mir den View ...
Könnte es sein dass Du einen Keyset Recordset (ADO oder ODBC) ... Der ist zwar für reinen
SQL Server Zugriff längst ... sp_prepare ausgeführt und das mag den Oracle Provider
verwirren. ... (microsoft.public.de.sqlserver) - Re: Oracle ADO query shows deleted records
... I construct a sql delete statement and fire it an Oracle ... > The
short answer is no, ADO doesn't cache anything. ... > it does cache records.
... (microsoft.public.data.ado) - Re: Limit of 1050 columns for ANSI joins
... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated
SQL on my system, ... Index your schema properly and think about the proper design.
... (comp.databases.oracle.server) - Re: I cant find a SETUP.EXE in the SQL Plus Client ??
... someone else's server for testing some SELECT statements I'm ... free client
because I don't own the Oracle license. ... SQL statements. ... There is
no documentation with that download. ... (comp.databases.oracle.tools)
