Re: Exporting Access data/import to Oracle

hi carlos,

> 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;

1. you surely defined the column as char(8) in oracle but you should use varchar2(8). then you are set.
2. im not sure about that but try: drop table "Query1";

-- 
cu maxx

to reply just remove the no-spam. from my address