Change from OLE DB to ODBC connection both connected to SQL Server?
I have an Excel file that was originally created with connection type being an OLE DB Query
. This oledb connects to a SQL Server database and executes a stored procedure dbo.usp_GetEmployees
which returns columns EmpId
, FName
, LName
.