Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have an ODBC connection, and therefore I do not have an .odc file. How can I use my connection with a data connection library so that it will work on Excel Services?

April 26, 2017connection Data Excel file library ODBC Services

0

Posted

I have an ODBC connection, and therefore I do not have an .odc file. How can I use my connection with a data connection library so that it will work on Excel Services?

1 Answer

0

Posted

Excel Services works only with .odc files. If you have a connection in a workbook that you want to save to a data connection library and have work with Excel Services, you will need to export that connection as an .odc file. The Export Connection File command from the Connection Properties dialog box described in Specifying the server authentication for an existing connectioncan be used to do this as it always exports .odc files.