Viewing 8 posts - 1 through 8 (of 8 total)
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...
December 12, 2008 at 11:27 am
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...
December 11, 2008 at 8:57 am
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...
December 11, 2008 at 8:44 am
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.
December 11, 2008 at 8:39 am
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...
December 11, 2008 at 8:29 am
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...
December 10, 2008 at 7:10 am
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...
December 3, 2008 at 2:02 pm
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...
December 3, 2008 at 1:30 pm
Viewing 8 posts - 1 through 8 (of 8 total)