MS/Access to Oracle [message #367937] |
Fri, 05 May 2000 17:13 |
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 |
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 |
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....
)
|
|
|