[AccessD] Exporting To Excel

Gustav Brock Gustav at cactus.dk
Sat Jul 26 01:24:28 CDT 2008


Hi Rocky

The major issue is that you can attach (link) a WorkBook or Named Range from an Excel file and read the data but neither update nor append as you could in earlier versions. This counts for A2003 and A2002/XP as well if you apply the latest "security" updates. A97 and A2000 are not affected.

/gustav

>>> rockysmolin at bchacc.com 25-07-2008 20:01 >>>
Dear List:
 
I have a client using 2007 who just came across a restriction on exporting
data to Excel.  IIRC, it was an anti-trust litigation thing.
 
Briefly, what can't you do in 2007 regarding automation with Excel?  Is
TrassferSpreadSheet still working?  Can you save the results of a query to
Excel?



 	
	
MTIA,

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 
-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list