Hello,
Could someone give me a solution please for the next situation?
I have an excel worksheet where I got a ODBC connection to a SQL Server.
The query represents an execution of a stored procedure with parameters.
I've tried to use SQLOLEDB because this way I don't have to create for each
SQL Server a DSN connection like I do for ODBC connection (and this would
improve a lot excel use), but the Refresh doesn't work if the query string
contains parameters (run time error 1004).
What can I do?
Any idea will be appreciated.
Thanks in advance.
Regards,
Lucian Rosu
Bookmarks