Home » RDBMS Server » Server Utilities » MS/Access to Oracle
MS/Access to Oracle [message #367937] Fri, 05 May 2000 17:13 Go to next message
billh
Messages: 35
Registered: August 1999
Member
I am in a situation where I need to create a temporary Access db. A permanent Oracle DB will soon be created. Can anybody point me to some doco. that highlights differences between MS/Access and Oracle? I am thinking about things like column names and ints, doubles, text, and memo column data types and subsequently porting the data from Access to Oracle.

Thanx in Advance
Re: MS/Access to Oracle [message #367942 is a reply to message #367937] Mon, 22 May 2000 12:52 Go to previous message
MarkJ
Messages: 17
Registered: July 1999
Junior Member
open a free user account at technet.oracle.com and then download the ms access migration kit. I have used it to migrate from access97 to oracle 805 and 815.
-Mark
Re: Tabs and SQLLoader [message #368046 is a reply to message #367937] Thu, 18 November 1999 17:58 Go to previous message
mary
Messages: 19
Registered: November 1999
Junior Member
For Tab-delimited fields:

LOAD DATA
INFILE 'FILENAME.TXT'
INTO TABLE t1
FIELDS DELIMITED BY x'09'
TRAILING NULLCOLS
( column 1....
)
Previous Topic: Migrating from SQL Server to Oracle ...
Next Topic: Re: Preferred Credentials setting error from Enterprise Manager
Goto Forum:
  


Current Time: Fri Mar 29 00:46:09 CDT 2024