Re: Access table importing

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Fri, 16 Apr 1999 10:06:32 -0400
Message-ID: <3717439b.0@news.mountain.net>

Yes, you can import from Access to Oracle using ODBC. A got-ya that I have found though.

Access puts double quotes around everything (ie. table_name and column names), so make sure the column names and table names in Access are in upper case and have no spaces in them or Oracle will preserve case and spaces which forces you to use the double quotes anytime you want to query the data in Oracle.

Kenny Gump

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 Fri Apr 16 1999 - 09:06:32 CDT