Hello All,

I am trying to dynamically change the SQL statement used for several queries in my excel worksheet. The queries pull information from an Access database. Basically, I need to change the source table in Access for the query in Excel. Is there an easy way to do this?

I am using Excel 97 and have set up the queries using MS Query.

Any help is appreciated.

Thanks in advance.