import table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import table

  1. #1
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282


    Hi.
    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.

    Tks.

    F.

  2. #2
    Join Date
    Jul 2001
    Location
    ksa
    Posts
    37
    hi Mnemonical
    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 ....

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    This will also work...

    Select * from "MyAccessTable"

    But, I'd go with the UPPER CASE suggestion!
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    You can drop the table(s) with

    DROP TABLE "MyDirtyLittleAccessTable"
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    Thank you very much mohammed, it worked well.
    I really appreciate it.

    F.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width