Access XP / .ADP and Transferspreadsheet issue with SPs

[Kyle Jedrusiak]

I have a SP that I can right-click on and export without any issue.

If I try to do it programatically using TransferSpreadsheet(..., SPName,
Filename, ...)

It tells me it cannot find the object SPName.

Doesn't matter what the name is. I have also tried dbo.SPName,
dbo_SPName.

Kyle!

 

[aaron.kempf]

uh try a view?

have you tried it with a macro also?

i think that sometimes i've had to push stuff from a sproc to a temp
table before exporting; i think that was on the original office 2000
version though..

do you have all the latest service packs for office
http://officeupdate.microsoft.com

-Aaron

 

[Malcolm Cook]

FWIW - neither can I - I get the same message
--malcolm

 

[Kyle Jedrusiak]

Apparently you HAVE to dump it to a table.

So I modified the existing SPs, plus added one to drop the tables after the
TransferSpreadsheet call is done.

Kyle!