(Excel must be on the machine though).
>From: Stefan Jahnke <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: AW: From Microsoft Access to Oracle
>Date: Tue, 18 Mar 2003 05:23:43 -0800
>
>Hi
Thanks
to all who replied...
santosh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Stefan JahnkeSent:
Tuesday, March 18, 2003 6:54 PMTo: Multiple recipients of list
ORACLE-LSubject: AW: From Microsoft Access to
Oracle
Hi
We
MS Excel
object to create them (Excel must be on the machine though).
From: Stefan Jahnke <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: AW: From Microsoft Access to Oracle
Date: Tue, 18 Mar 2003 05:23:43
e recipients of list ORACLE-LBetreff:
Re: From Microsoft Access to Oracle
The easiest way is to ODBC link the tables and
develop like it is an MS Access project.
This is not the best way due to security and a
host of other issues.
I have seen using ADO & oo4o through VBA
to make the
Santosh - Hopefully someone with more Access experience will reply, but from
what I understand you want to create the Oracle table first. Access can
create Oracle tables but it tends to use goofy data types. Then Access can
connect to that table.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetou
the average MS Access database project.
OTN has some great sections of using ADO and
oo4o.
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, March 18, 2003 1:08
AM
Subject: From Microsoft Access to
Oracle
H
Hello
list,
I want
to create a new form in Access where user input will be thereand the data
entered i have to store it in Oracle database.
Can anyone of you
guide me in doing this..How ???
Thanks and Regards,
Santosh