Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: Oracle to Access Dump

    Hi, I am fairly new to databases so this may seem like a stupid question. We have a very large Oracle database with 400 or so tables that we would like export to Access once a week so that we can use it for various projects. I know that you can do a dump from oracle but then we cannot use it as easily as using it straight through Access. Right now I am using make table queries from Oracle to create the tables but I am only getting the 50 or so tables that I made the queries for. I don't want to create 400 plus make-table queries. Is there a fast ,quick and dirty way to export that I can do to get all the tables in one Access database?

    Thanks

    Sherriff

    Jsherrif@hamilton.ca

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    if all of the tables are the same structure (fields and data types) you could probably do some kind of Union query

Posting Permissions

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