Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prompt before updating values
HI,
I have an SQLREQUEST function which is a simple select query that retrieves data from oracle tables. ='C:\Program Files\Microsoft Office\Office10\LIBRARY\MSQUERY\XLODBC.XLA'!SQL.RE QUEST("DSN=BATSERV;UID=GCOMM;PWD=GCOMM",,,"SELECT nvl(SUM(VERT),0) FROM btc_tblock_count_exch WHERE type1='BT Line' AND exch='RMN' and TO_CHAR(inservicedate,'yyyy')='1988'") How can i issue a prompt on exch column as soon as i open the xls to update the data accordingly. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions |