Access XP / .ADP and Transferspreadsheet issue with SPs

  • Thread starter Thread starter Kyle Jedrusiak
  • Start date Start date
K

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!
 
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
 
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!
 
Back
Top