Home » SQL & PL/SQL » SQL & PL/SQL » Oracle to Access file without using any utility Tool (Oracle 10g)
Oracle to Access file without using any utility Tool [message #354205] Fri, 17 October 2008 00:28 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
How can we convert a oracle data into Access file using query but without using any utility tools ,Is it possible to do the above said process if means can anyone help reg this

Thanks in advance,
Re: Oracle to Access file without using any utility Tool [message #354210 is a reply to message #354205] Fri, 17 October 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you know what Access file format is, you can do it. (Almost) nothing is impossible to program.

Regards
Michel
Re: Oracle to Access file without using any utility Tool [message #354284 is a reply to message #354210] Fri, 17 October 2008 06:24 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

without using any utility tools



Also depends on what he means with "utility tools".

Even when you can write a query that creates the binary access file format, how do you run it without at least running the SQL*Plus tool? Very Happy

There is one possibility I can think of using Access.

Here is a function I use in Access to create a table link in access to a table in an Oracle database that is access via ODBC.

Warning!! Access VBA Code!! Pain!!

Public Function ChangeDBLink (
  LocalTabelle As String, 
  RemoteTabelle As String)
   
  Dim dbsCurrent   As Object
  Dim tdfLinked    As Object
  Dim tdfOldLinked As Object
  Dim prpLoop      As Object
   
  Const dbAttachSavePWD As Long = 131072
   
  ' Open Database
   
  Set dbsCurrent = CurrentDb
   
  On Error Resume Next
  dbsCurrent.TableDefs.Delete (LocaleTabelle)
  On Error GoTo 0
   
  ' Create Linked Table
   
   Set tdfLinked = _
      dbsCurrent.CreateTableDef(LocaleTabelle)
   tdfLinked.Connect = _
      "ODBC;DATABASE=orcl;UID=scott;PWD=tiger;DSN=odbc_name"
   tdfLinked.SourceTableName = RemoteTabelle
   tdfLinked.Attributes = dbAttachSavePWD
   
   dbsCurrent.TableDefs.Append tdfLinked

   tdfLinked.refreshlink

End Function


One COULD use that to create links to the data dictionary, and then linking / transferring all tables.

But that would basically mean you don't only USE a utility tool, you basically also WRITE it yourself, which wouldn't make much sense in most cases.
Previous Topic: "ORA-12519: TNS:no appropriate service handler found"
Next Topic: Delete data
Goto Forum:
  


Current Time: Sun Dec 04 21:02:28 CST 2016

Total time taken to generate the page: 0.08613 seconds