Import from Web-Based Database; Oracle

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

I am attempting to import data from a table that I just created in an Oracle
DB. I've worked with Access DB's before that did this, but I didn't set that
up, it was working fine when I inherited it. Now, I have to establish a
connection between the web-based DB and my own Access DB. How do I get
started? I have the Login ID and password and that's it.

Regards,
Ryan---
 
In a Macro, I have the following:
Transfer Type: Import
Database Type: ODBC Database
Database Name: Oracle (although I’m not sure this is literally the name of
the Db, how can I tell for sure)
Object Type: Table
Source: (I copied/pasted the http link in here but I get a message saying
‘the text is too long to be edited’)
Destination: Table1
Structure Only: Yes

Anyway, that’s where I am now.

Any help would be greatly appreciated…
 
Back
Top