>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.

Never mind. For those who may be interested, I'm selecting ODBC over OLE because of less coding and better performance (at least on the PC's where the app will run). The approach I'll be taking is to create a separate DSN for each user-maintained excel workbook. Then in the VFP database there will be one connection for each of the DSN's created. In that way, the user does not need to know the file name of the excel spreadsheet (each of the spreadsheets are owned by different users) and I get to use ODBC over OLE.