Excel has its own method of importing external data from a variety of sources, including data in the SQL Server. This method can be embedded directly in the workbook or stored in a separate file, the Office Data Connection (ODC) file. When this
.odc file is created, it can be reused over and over for a quick connection between your GP and Excel that is refreshable.
Let's create an
.odc file to bring in our vendors using these steps: