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

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


"Joe Fallon" wrote:

> 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.
> --
> Joe Fallon
> Access MVP
>
>
>
> "sunil Tharavath via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
> message news:5b4e31531e0d4de09e11aeb678592b9c@xxxxxxxxxxxxxxxxxxxx
> > 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
> >
> > --
> > Message posted via http://www.accessmonster.com
>
>
>
.

Relevant Pages