Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a QueryTable.Refresh solution
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost: Update querytable connections and refresh data | Excel Discussion (Misc queries) | |||
Update querytable connections and refresh data | Excel Discussion (Misc queries) | |||
Update querytable connections and refresh data | Charts and Charting in Excel | |||
A QueryTable refresh, a named range, the 'Hidden' property | Excel Programming | |||
catching cancel on QueryTable.Refresh | Excel Programming |