View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
adolf garlic adolf garlic is offline
external usenet poster
 
Posts: 7
Default how to deploy xls with config based conn str (Dev vs Test vs Prod)

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?