Connection strings and select into queries

[feltondude]

I am trying to create a make table query in Access that pulls data from an Oracle database table. The Oracle databse is listed in my TNSNAMES file. I'm looking for an example of a select or select into statement where the connection string to the database, username and password is included.

I've done this before, but I can't find the old access database that had the query I'm modelling this after.

Thanks

 

[Banana]

Something like this, perhaps...

SELECT * INTO MyNewTableName FROM [<connectionstringtoOracle>].NameOfTableOnOracle;

 

[feltondude]

Something like this, perhaps...

SELECT * INTO MyNewTableName FROM [<connectionstringtoOracle>].NameOfTableOnOracle;

I think that is it. Now I just need to figure out what the connection string to our Oracle apps database would be. I know in the poast, the string contained references to "uid" and "pwd" but I don't know the syntax.

 

[Banana]

Take a look at Carl Prothman's connection string. He lists various forms of Oracle connection string.