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 selected fields in an external table 4
Linking Access to selected fields in a large external table 1
Database name added to link tables! 1
Linking to a linked table 2
Embed Username & Password in Oracle External Linked Table 1
How do I break a link to an external database but keep table data? 1
Create Linked tables in access db without ODBC 18
ODBC Linked Tables 0

Top