Conversions when Linking to an External Table

M

mcl

OK, I'm dealing with weather data here. I've been linking to external tables
in oracle using ODBC.
For example the temperatures in oracle are celcius * 10. So 10.5C would be
105 (TempC10 is field name). Is it possible when linking to do the
conversion on the fly (rather that using a query later) and having the table
in the linked table display the temp in F, ie. TempC10*.18+32?
 
P

Paul Overway

You should probably create a view on the server and link to that instead.
Otherwise, you're stuck using a query within Access to do the conversions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to a linked table 2
linking tables to an external source? 3
Linking to selected fields in an external table 4
Linking Access to selected fields in a large external table 1
Linking Access and Oracle problem 4
External database linking 1
ODBC - Connecting MS Access to Oracle 10g 2
linking oracle to access 1

Top