• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 702
  • Last Modified:

Export tables from oracle to Microsoft access

I have toad installed and have access to oracle tables that need to be exported to a local access db. Please explain step by step how it is to be done.
0
PearlJamFanatic
Asked:
PearlJamFanatic
  • 5
  • 4
  • 2
  • +1
1 Solution
 
enachemcCommented:
export the tables as SQL (it will generate a lot of simple insert instructions per file) and execute the files in access
0
 
PearlJamFanaticAuthor Commented:
how do i export table structure?
I have to create the tables as well in the blank access db
0
 
MarioAlcaideCommented:
Hi, you can use this software:
http://www.spectralcore.com/fullconvert/tutorials/convert-oracle-to-access.php

You have to pay, but there is a trial version that maybe fits your needs.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
enachemcCommented:
In the schema browser, select tables. IN the Left Hand Side (LHS) select
the tables you want to create elsewhere. Right click and select "create
script". Fill in the options and OK.
0
 
PearlJamFanaticAuthor Commented:
enachemc:i did what you suggested. Now I have 2 .sql files. How do i run them in MS access
0
 
OP_ZaharinCommented:
1- first you need to create a duplicate Oracle table in Access.
2- you might need to change some of the datatype, as the datatype in Access is different from Oracle. run the script in Access.
3- export the Oracle data using Toad's Export option and choose export to CSV file format.
4- then import the data into Access. here is the steps to import data into Access using CSV files: http://www.brighthub.com/computing/windows-platform/articles/27511.aspx

0
 
PearlJamFanaticAuthor Commented:
OP_Zaharin:csv is not shown as an option when exporting from oracle. can you give the exact steps.
When i select .txt option it writes insert commands for each row
0
 
OP_ZaharinCommented:
whats the Toad version are u using?
0
 
PearlJamFanaticAuthor Commented:
9.0.1.8
0
 
OP_ZaharinCommented:
0
 
PearlJamFanaticAuthor Commented:
There is no export wizard option within toad
0
 
OP_ZaharinCommented:
try this: select the table from the schema browser and right click, choose save as then choose CSV.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now