Re: Exporting ms-access 2000 tables with Yes/No fields to Oracle 8.1.6

From: upton <j.upton_at_gte.net>
Date: Mon, 28 Aug 2000 01:53:45 GMT
Message-ID: <ICjq5.7957$td3.828675@dfiatx1-snr1.gtei.net>

Huw G wrote in message <39a635f0_2_at_nnrp1.news.uk.psi.net>...
>I am testing ODBC drivers by exporting the Northwind Traders tables from
>MS-Access 2000 to Oracle 8.1.6 (all running under Windows 2000). The
>Products table cannot be exported because Access tries to export the
>Discontinued field, which is Yes/No type, in the format VARCHAR2(0). Oracle
>objects to zero-length fields and fails to create the table.
>
>Microsoft's, OpenLink's and Oracle's own ODBC drivers all behave in the
same
>fashion.
>
>Thanks in advance for any information anyone may have.
>
>
>

If you use the SQL Loader in Oracle 8 you can write a comparison and assignment modifier to the target table to fit the Oracle table you're populating. (I.E. check for the yes/no type and change it to VARCHAR2(3) or VARCHAR2(1) whichever you prefer) check the docs for more detail and examples.

~Ryan Received on Sun Aug 27 2000 - 20:53:45 CDT