Thanks for the suggestion. Everything works fine for me until I go to click the final OK to import the data. Then I get the Invalid Parameter Number...

Just to try something different, I created the connection through MSQuery. I used the SQL box and successfully got

exec proc_exceltest '12/10/2008' to work. As soon as I...

Eric,

I was trying to do this directly from the connection properties, without using Query. When I tried this from the connection properties

{call proc_exceltest(?)}, I get 'no value...

I hadn't but when I just tried

{call proc_exceltest(Sheet1$I1)} I got the same error.

Any other thoughts? I have not been able to find a decent language reference anywhere.

Thanks for the help. I was able to get the following to work:

{call proc_exceltest('12/1/2008')}, but as soon as I change it to

{call proc_exceltest('Sheet1$I1')}, I get an error (invalid...

Good morning,

I'm still struggling with this issue, so any help would be appreciated. Just to refresh, I'm trying to call a SQL 2000 stored procedure from Excel...

Thanks for the quick reply. At the risk of baring all of my ignorance at once, that looks like VBA (?). Unfortunately, all I know about VBA is...

Thanks for the interesting discussion on this topic. It's good to know I'm not alone in working these issues out. That said, I have a slightly different twist...

I'm...