What if we want to source the data from a stored procedure, not directly from a table.
After the OLE DB connection is created, and when Excel is ready to import data, click the Properties button.
In this Connection Properties window, change the Command Type from Table to Default, and enter the command to execute the stored procedure.
No comments:
Post a Comment