Re: Exporting Access data/import to Oracle

    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 Received on Mon Jun 29 1998 - 00:00:00 CDT