| export [message #373415] |
Mon, 16 April 2001 09:14  |
aish
Messages: 44
Registered: March 2001
|
Member |
|
|
|
I want to export all the tables and data from oracle (8.0) to Ms acess how do I do that ?
|
|
|
|
| Re: export [message #373417 is a reply to message #373415] |
Mon, 16 April 2001 09:48  |
Siddharth Bahri
Messages: 18
Registered: March 2001
|
Junior Member |
|
|
Hi Aish,
To Import data from Oracle to access first create an odbc dsn for your oracle table.
Then within the tables tab of ms-access right click and choose import. A dialog box will appear.
Choose ODBC Databases from 'Files of Type' drop down and choose your oracle dsn.
I am sure you will fly through the rest.
Another alternative is to use SQL Server's Import and Export Wizard.
rgds,
Siddharth
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
