Problem in exporting MsAccess database to Oracle....How can i expo

S

Sunil

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem in exporting table from MSAccess to Oracle.... 3
Problem when linking to Oracle Database 0
Export Delimited 3
How do i export selected columns from excel to an Oracle database 3
Problems Exporting from Access 3
Export table to other database problem in Access 97 on XP 0
Want to export some but not all records 7
Export issue 1

Top