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?