Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    76

    Question Unanswered: Access 2000 table import to Oracle 10g

    Hi I am trying to import a table data from Access 2000 table into a table in Oralce 10g. I am using the toad table import utility. Every time I go thru the setup in the end I get this error.

    Complie Error: Syntax fault.

    I am not really sure whats going on over here. I have tried changing the data types around but the same issue. I can't find anything on the web for this. Here are the data types I am using

    Access -- Oracle
    text(25) -- varchar2(30)
    number(long Integer) -- number(I am not giving any length for this)

    I have tried changing between number and integer for the oracle column but it dosent seem to work.

    any ideas??

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    76
    No we cant do this. I am familiar with this and this article is very useful. I want to do exactly what I mentioned. I want to do a table import from Access 2000 into Oracle 10g, without a DB link or making entries to a TNS names files etc.

    Now is this not possible to do an import from access to oracle without the tnsname setup?

    Thanks for your help.

  4. #4
    Join Date
    Nov 2003
    Posts
    76
    we dont have a license for hs odbc, so we cant use this approach.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Export the Data out of Access to a csv quote delimited file?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2003
    Posts
    76
    I know, we can do this also, (and I am having to do this )but this is something which will be done once a month. My thought was to set up an import once. Then schedule it on a DBMS job. I wont be around to do this every month.

Posting Permissions

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