This content has been marked as final. Show 6 replies
Access can read in .csv files.
Is it possible for you to spool the file out as a .csv and import from there?
Thanks for the reply.
I have created file in a .csv format.
But I need the get the data specifically in an access format.
I'm not aware of any in built functionality, you may have some luck with a third party tool.
Can you not just create a linked table from access directly to oracle for this?
Use one of the following method :
1- Spool file ----> then open it with MS excel ---> save it to format you want. 2- Tools : pl/sql developer, TOAD .... 3- using ODBC
user11979518 wrote:You will be able to dump all the oracle schemas using ODBC.
I am running Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production on Solaris 10.
I want to extract table data in an access format.
How can I do that ?
Thanks in advance...
.Open MS-Acess-->Create ODBC connection-->select ODBC oracle driver-->then select target oracle schema and dump