i just created a connection between excel and sql,i want to be able to maintain the connection with the database so that each time the workboob is refreshed update can be made on the excel workbook that i saved as an html page.

Hi, I don't understand you completely. Do you want the update info to display on a report so that you can monitor them. If so, you can set the report' AutoRefresh property. thanks, Jerry

i want to import a database into excel,publish it online and still maintain connection with the database,so that when changes are made in the database and the page is refreshed it will reflect in the excel workbook published on online.