I'm using ODBC to run a SQL Select statement to an excel spreadsheet. Every time I open the connection it asks for a file name, even though I've specified that in the view designer. Is there a way to embed the file name so the user doesn't need to know the source file name?

Thanks in advance.