Re: Access table importing

From: Rian Hawkins <snikwah_at_mindless.com>
Date: Thu, 15 Apr 1999 14:18:48 -0700
Message-ID: <jNsR2.2725$kr1.49829@news7.ispnews.com>

We have done that exact thing many times. It works just like you said. Problems we have encountered:
Conversion of data types is not always clean. We had Long Integer fields defined in access that converted to Float in Oracle. If you have many tables to export, a macro in Access will save a lot of time, you can export hundreds at a time if necessary. Dynamic SQL scripts can also be used to change the Float back to something a little closer to what is should be. We also had short field and table names without spaces which helps.

Hope this helps a little.

Rian Hawkins
Sys Admin
Comptek Federal Systems

Patrick Brassil wrote in message ...
>Hi, got a quick question here.
>
>We have a large Access database table that we need to move to Oracle. I'm
>pretty sure that, since Oracle know ODBC, that I can just go into ODBC (in
>WinNT control panel) and make a .dsn to point to a database in Oracle.
>Then I can 'save as/export' the table in Access to the Oracle database
using
>the usual export procedure.
>
>My boss needs me to confirm this for the customer (who has the Oracle
>server) before we commit to the job. Can anyone here confirm that is
>doable, and if there are any cautions or limitations that we need to be
>aware of?
>
>
>Patrick Brassil
>pbrassil_at_bachsystems.com
>
>
Received on Thu Apr 15 1999 - 16:18:48 CDT