Sir,

I have created an excel file abc.xls and connected it with my vfp program through two methods :

(1) odbc connection
(2) excel automation commands

By both the methods when I change the values in excel files and refresh the sql query, the these are also reflected in
the vfp program. Upto that every thing works fine.

In odine stock exchange program, we can create the excel file arbitrage.xls which also shows the current values of
selected scripts. I want to connect this excel file with my vfp program through odbc connection or through excel automation
commands. When I refresh the sql query, the vfp program does not show the updated vales in the arbitrage.xls file which are
changed automatically by the odine stock exchange program, but it show the values which are saved in the arbitrage.xls.

I have also tried to link the arbitrage.xls with Microsoft Access Database and then connect this database through ODBC
connection. But it also shows the saved values in the arbitrage.xls.

Please guide me so that I can get the current values of the arbitrage.xls in my vfp program.

Thanks.