I am attempting to set up a DSN and query from Excel to an Oracle database. The problem I am fighting is where the DSN and .dqy need to be saved. At this point, if I set up a DSN and a copy of the .dqy then it works. I would like to be to just set it up on the server once but I don't know how. I'm new to the Excel part so perhaps I'm missing something basic?