Re: Exporting Access data/import to Oracle

calberto_at_my-dejanews.com wrote:

> Hi all!
>
> I have some problems to transfer data from Sybase to Oracle. I used Access
>like an interface to do this. The first is :
>
>1) A char(8) column in my Sybase's table which has data with 6 characters only
>is generated with the data followed with blank spaces to Oracle. It seems that
>Access doesn't have datatype char and therefore it converts to the maximum
>length of the column;
>
>2) I can't drop a table with lowercase characters(like 'Query1') in Oracle
>generated by Access. It appears in ALL_TABLES but when I try to drop it,
>Oracle tells me that this table doesn't exist;
>
>Can anyone tell me how to avoid these problems?
>
>Thanks in advanced,
>
>Carlos
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

I.m not sure about the first problem but for the second you need to enclose the table name in quotes... like drop table "lower_case_name";

That will do it... Received on Mon Jun 29 1998 - 00:00:00 CDT