Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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.

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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...

  • RE: Excel with Stored Procedures

    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...

Viewing 8 posts - 1 through 8 (of 8 total)