View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ravindra Joshi Ravindra Joshi is offline
external usenet poster
 
Posts: 1
Default How do I create and save .odc and .oqy files in excel?

I need to create a OLAP data source connection pointing to Analysis Services
in a server present in different domain. I want to provide Username and
Password required to connect to this server also in this data source
connection; How do I define it and save it? Which one is preferred? .odc or
..oqy? How do I save them in the folder I want?