how to deploy xls with config based conn str (Dev vs Test vs Prod)

A

adolf garlic

We have a lot of xls with vba/addins and so on that we are migrating to have
all the SQL as stored procs (with other enhancements coming later)

However, we want to fully control where a given xls gets its data from

Production, Test, Development etc

Is there a nAnt script or other deployment product that can do this?
If not, what workarounds do people use?
 
Top