problem in exporting table from MSAccess to Oracle....

  • Thread starter Thread starter sunil Tharavath via AccessMonster.com
  • Start date Start date
S

sunil Tharavath via AccessMonster.com

hi,

I am a novice to Access 2000..i want to export a MsAccess database to
Oracle...i am using "TransferDatabase" Macro available in MsAccess...The
Macro is running perfectly...But the problem is when i export a table from
Access2000 to oracle,Oracle lists that Exported table name.(ie if u type
select * from tab;)....but when i type DESC EXPORTEDTABLENAME (Eg desc
emp_tab;) oracle shows a error message ie Table or view does not exists....
Next i imported that exported table (ie emp_tab) into my Access2000 again
,now its shows the table in correct format(including data and structure)
.....why is it so?
why oracle is showing that error even that table name is listing?

Can any one Help me out ?

Thanks in advance

With best regards

Sunil.T
 
I would not do it that way but...

Did you give the Oracle user permissions to read (SELECT) from the new
table?

I would create the table in Oracle.
Then use an Append query in Access to put data in it.
 
Hi ,

am using the default usrname and password for oracle(ie scott and tiger)
and i dont think this user is not needed a read permission...
Thanks
best regards
Sunil.T
 
hi,

i figure out in my own
here is the macro.....any body interested can use it

*******
Macroname : Transferdatabase
Transfer type : export
Database type :ODBC database
Database name : ODBC Connection string (Eg :
ODBC;DATABASE=;DSN=sun;UID=scott;PWD=tiger;)
Object type : table
Source : Table name(ur table name in MsAccess...)
Destination : Destination table name ( PROBLEM IS U HAVE 2 TYPE THE
DESTINATION TABLE NAME IN CAPS)
Structure Only : yes/no

*******

if any body have any other idea pls let me know....
thanks in advance..

With best regards
sunil.T
 
Back
Top