RE: Reading records from Access to Oracle -HELP!!

From: Ruiz, Mary A (CAP, CDI) <Mary.Ruiz_at_gecapital.com>
Date: Tue, 21 Nov 2000 14:29:20 -0500
Message-Id: <10687.122653@fatcity.com>

Fred:
If your table has all text columns, the best way is to create an ODBC datasource for your Oracle database, Highlight the table, click on File .. Save As/Export and in the export Wizard, there is a pull down for Files of Type ... Choose ODBC Datasources and then specify the name of your oracle database. Be sure all of the columns in the table are upper case, with no blanks in them. Same for the name of the table. If the MS Access table has non-text columns, this method does not work very well. For example, columns that are double precision get converted to varchar2(40) in the export process. In this case, you can export the Microsoft access table to a comma delimited file and run sqlldr.

If the table is small, then you can get away with writing an "Append" query to append the contents of your MS Access table to the empty table residing in the Oracle database.

hope this helps,

Mary Ruiz / Atlanta GA

-----Original Message-----
From: Fred Smith
Sent: Tuesday, November 21, 2000 12:05 PM To: Multiple recipients of list ORACLE-L 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 Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: 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 - 13:29:20 CST