Hello,

I can't seem to use the docmd.transferspreadsheet using Views or Stored 
Procedures on an Access ADP.  I keep getting an error that says "Microsoft 
Access can't find the object 'ViewB_EmployeesUnit'".  Is this supported at 
all?  I mean can you export to Excel using Views and Stored Procedures?  
I've tried with it both and had no luck.  My code looks something like 
this:

DoCmd.TransferSpreadsheet acExport, , "ViewB_TransferSpreadsheet", strSave

I even tried to replace the View with a stored procedure.  I actually 
prefer it to be a stored procedure so that i can sort it.  I know with 
Access queries you can do this but is it possible using Views and stored 
procedures in SQL Server 2000?  Any ideas? hints? suggestions? help?  
Thanks!

Emmanuel

> Hello,
Correction:  I meant the ViewB_TransferSpreadsheet to 
be 'ViewB_EmployeesUnit'"  Copied and pasted the wrong one. It really 
should be 

DoCmd.TransferSpreadsheet acExport, , "ViewB_EmployeesUnit", strSave

> I can't seem to use the docmd.transferspreadsheet using Views or Stored 
P> rocedures on an Access ADP.  I keep getting an error that 
says "Microsoft 
A> ccess can't find the object 'ViewB_EmployeesUnit'".  Is this supported 
at 
a> ll?  I mean can you export to Excel using Views and Stored Procedures?  
I> 've tried with it both and had no luck.  My code looks something like 
t> his:

> DoCmd.TransferSpreadsheet acExport, , "ViewB_TransferSpreadsheet", 
strSave

> I even tried to replace the View with a stored procedure.  I actually 
p> refer it to be a stored procedure so that i can sort it.  I know with 
A> ccess queries you can do this but is it possible using Views and stored 
p> rocedures in SQL Server 2000?  Any ideas? hints? suggestions? help?  
T> hanks!

> Emmanuel