How to transfer a table from Oracle to MS Access?

Question

Oracle

How to transfer a table from Oracle to MS Access?
More interested in structure than data.

Answer 1

In general, the question is from the series "how to transfer from a car to a scooter", but ...
An ODBC driver is needed. Put it on the win where access. The access help describes how to connect to ms sql and oracle. Connect.

Dim wrkODBC As Workspace
Dim Dbs As Database
Dim Rs As Recordset

Set wrkODBC = CreateWorkspace('', 'Login', '', dbUseODBC)
Set Dbs = wrkODBC.OpenConnection('', , , 'ODBC;UID=Login;PWD=PasswordSN=OracleDSN')
strSQL = 'SELECT .... '
Set Rs = Dbs.OpenRecordset(strSQL, dbOpenDynaset)

Further request drag the data from oracle in object access. I won’t give the code here, I myself have never done such horror, I can screw it up.

Answer 2

Does the table have more than 1000 fields? If not, then it will take less than 15 minutes by hand.

Answer 3

Import a table from another database .