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

From: Troiano, Paul (CAP, GEFA) <Paul.Troiano_at_gecapital.com>
Date: Tue, 21 Nov 2000 12:45:35 -0500
Message-Id: <10687.122636@fatcity.com>

How big is the table? For a few hundred thousand records or less I would just link them via ODBC and use a select into statement from the sql view of a new query. Once you know how to do this, it can be done very fast.

If larger, export as fixed width, or comma delimited, if possible, and use sqlldr.

HTH
- Paul

		-----Original Message-----
		From:	Fred Smith [mailto:fred_fred_1_at_hotmail.com]
		Sent:	Tuesday, November 21, 2000 10:05 AM
		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

Received on Tue Nov 21 2000 - 11:45:35 CST