Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    1

    Smile Unanswered: connection between access and oracle

    Good evening
    I need your assistance for the construction of my dated warehouse. Me I carried out the model out of star and I want to use this last to build script corresponds to use it in oracle. And also the important point is the realization of connection between the data base ACCESS and the data base in oracle, i.e to connect itself to DBMS ACCESS, to extract the data and to charge them on table in oracle.
    Thank you and good continuation.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can use ODBC
    Be warned that ACCESS is a case insensitive DB; while Oracle is case sensitive.
    You should UPPER CASE everything going into Oracle
    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.

Posting Permissions

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