Re: Loading Access data into Oracle DB

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/05/11
Message-ID: <391b0c63.512356810@news.earthlink.net>#1/1

and use MS provided ODBC dirvers, not Oracle.

On Wed, 03 May 2000 15:36:42 GMT, marcpark_at_my-deja.com wrote:

>Set up an ODBC driver for Oracle.
>Then run access and open your database.
>Select as as export file/data from the file menu
>Select file type as ODBC database.
>...
>
>Marc Parkinson
>
>In article <8enjnj$31k$1_at_nnrp1.deja.com>,
> jatin15_at_my-deja.com wrote:
>> I need to convert MS Access data into Oracle .
>> What Are the options for doing this.......apart
>> from SQL Loader.
>>
>> I used Sql loader & for that I have to convert
>> Access data to a flat file.
>> But when I export(from Access) a table with
>> numeric columns,
>> the values are truncated after second place from
>> decmal,e.g
>> 1.23456 is converted to 1.23 in the flat file.
>>
>> Thanks in advance
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Thu May 11 2000 - 00:00:00 CDT