| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reading records from Access to Oracle -HELP!!
create an odbc dsn for the oracle database. Open the ms access table and LINK
the destination oracle table. Write an Append query in ms access Run it. You
got it:>
Hannah
"Fred Smith" <fred_fred_1_at_hotmail.com> on 11/21/2000 12:05:23 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Reading records from Access to Oracle -HELP!!
List,
I was looking for anyone that has an idea of the best way to be able to select records that exist in a table in Microsoft Access into a table in Oracle. Has anyone done this? What is the best method of doing this?
I'm on Oracle 8.0.5.2.1 on Windows NT.
Thanks,
-Fred S.
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fred Smith
INET: fred_fred_1_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 21 2000 - 12:11:54 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |