sgleeson
Last Activity: Jan 5 '14, 03:45 AM
Joined: Nov 11 '08
Location:
-
could you post the SQL in the ms Query that has the parameters? -
There is a method using a DSN connection the sytax is {call [procname](?,?)} add ?'s for extra parms. You can reference cells in the Excel sheet. To get to this, Import External Data, New Database Query, then click through any table from the DB the the Proc lives, then view query and click on the SQL button in ms Query, then simply enter the above in place of what ever SQL is there.Leave a comment:
No activity results to display
Leave a comment: