|Re: Oracle to Access file without using any utility Tool [message #354284 is a reply to message #354210]
||Fri, 17 October 2008 06:24
Registered: April 2005
Location: Heilbronn, Germany
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?
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
On Error GoTo 0
' Create Linked Table
Set tdfLinked = _
tdfLinked.Connect = _
tdfLinked.SourceTableName = RemoteTabelle
tdfLinked.Attributes = dbAttachSavePWD
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.