Re: Transferring a table to Oracle:

I ran into this about a month ago. The problem was with the name that I had given the table. Access lets you name the tables using lower case characters and spaces. Oracle will let the table in with this, but you won't be able to pull any data from it. Make sure you use all caps and underscores if you need spaces.

Chris

"Andoni OConchubhair" <andoni_at_staff.tutticom.com.NOSPAM> wrote in message news:3A0AE986.2A8AC079_at_staff.tutticom.com.NOSPAM...
> Hi,
>
> I am using Access 2000 and Oracle 8i (for Linux)
> I am trying to move a table over my ODBC connection from my Access
> database to my Oracle database.
>
> I have set up a working ODBC connection and this part works fine as I
> have linked all the table from my Oracle database into my Access
> database and I can see their info fine.
>
> I am following the steps in the Access help pages about transferring to
> oracle and I follow the steps with no problems at all.
> But: when I then go to my Oracle database and try to select from the
> table I have moved across it prevents me saying the table does not exist
> (not that it is empty). On the other hand there is an entry for the
> table's name in the user_tables table.
>
> Please help if you have seen this before etc. Any and all ideas are
> welcome.
>
> Thanks in advance,
> Andoni OConchubhair
>
Received on Sun Nov 12 2000 - 15:04:39 CET