Re: Export MS-ACCESS Table
From: Jeffery D. Thomas <jdthomas_at_erinet.com>
Date: 1995/10/27
Message-ID: <46p8vp$onj_at_eri1.erinet.com>#1/1
Date: 1995/10/27
Message-ID: <46p8vp$onj_at_eri1.erinet.com>#1/1
m.kuenicke_at_fh-offenburg.de (M.kuenicke) wrote:
>Hallo,
>I exported a MS-Access 2.0 in ORACLE. ORACLE is installed on a IBM RS/6000.
>The export-procedure is ok.
>But I can not modify, drop the table in ORACLE, the Command-String select *
>from tabs shows the exported (ACCESS) table.
>Thanks in advance
>Michael
When you export a table from Access to Oracle, you MUST ensure that the table name and all field names are in uppercase. In addition, make sure that you don't have spaces embedded within any table or field names. Replace embedded spaces with underscores, for instance. In other words, make sure your Access table/field names conforms to Oracle naming conventions.
+-----------------------------------------------------------+ + Jeff Thomas jdthomas_at_erinet.com + + thomasjd_at_email.wpafb.af.mil + +-----------------------------------------------------------+Received on Fri Oct 27 1995 - 00:00:00 CET