[AccessD] Export to excel

Dan Waters df.waters at comcast.net
Wed Nov 9 15:09:19 CST 2011


Give everyone a shortcut to an access database that does nothing but export
that spreadsheet.  The access database should automatically, open, export,
and close.  Walla!  Snapshot in time.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, November 09, 2011 3:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export to excel

Or,  unless you need a snapshot at one point in time.


On 9 Nov 2011 at 15:26, Mark Simms wrote:

> 
> IMHO, this approach really beats all of the others....despite the huge 
> hassle that Microsoft has imposed for complex queries Every time you 
> open the Excel workbook....boom...the latest data is just "there". 
> Better yet: it can be refreshed every 30/60/whatever minutes....even 
> when users are changing the data.
> 


--
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