I have exported a table from ACCESS using Oracle ODBC.
It created a table in my schema, but when I query the
table, sqlplus returns the message 'table does not exist'.
What is it? How do I import a table exported by ACCESS?
It was exported, but I'm getting that error.
before export from access you must do :-
1-change the table name to upper (EMP).
2-change the table columns to upper (ENAME).
try this it will be work and don't forget drop the previous tables i hope this useful ...
If There Is somthing to do it just do it with oracle ....
This will also work...
Select * from "MyAccessTable"
But, I'd go with the UPPER CASE suggestion!
You can drop the table(s) with
DROP TABLE "MyDirtyLittleAccessTable"
Thank you very much mohammed, it worked well.
I really appreciate it.
Click Here to Expand Forum to Full Width