[AccessD] Updating Excel From Access

What????!!!! You mean it just can't be done??? Whoa. There MUST be a
workaround, surely. What, none?

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: 06 January 2007 16:21
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Updating Excel From Access
> 
> 
> Hi Andy,
> 
> A few months ago MS lost a patent lawsuit which required them 
> to remove the ability they had to update a linked Excel 
> spreadsheet.  Access was then changed in one of the MS 
> updates you've installed since then, and of course it doesn't 
> work in Access 2007.
> 
> Personally, it seems to me like they could have settled this.
> 
> At least you didn't break it!
> 
> Dan Waters
> 
> -----Original Message-----
> Subject: [AccessD] Updating Excel From Access
> 
> Hi folks
> Years ago I wrote a little Access MDB for someone under A97. 
> It's dead simple. It reads a column of data from 1 Excel 
> sheet via a query into an Access table which has a unique 
> index on that column/field (thereby deduplicating the data) 
> then writes that table back out to Excel worksheet 2 via a 
> second append query. Piece of cake. Except that I get a call 
> from this guy to say they've gone to A2007 and it's stopped 
> working. Now I don't have A2007 but I do have AXP so I loaded 
> it into that. Sure enough it fails because the query which 
> appends from the Access table to the 2nd Excel worksheet says 
> the query must be updateable and when I open the Excel 
> worksheet via the Access link to it sure enough it's 
> read-only. This must be one of those god-awful MS security 
> 'enhancements' I guess. What's the solution. So the long 
> pre-amble leads to the simple question - how do I make a 
> linked Excel worksheet updateable?
> 
> -- Andy Lacey
> http://www.minstersystems.co.uk 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>