[AccessD] Updating Excel From Access

JWColby jwcolby at colbyconsulting.com
Sat Jan 6 10:51:27 CST 2007


The workaround is to not "link" to the spreadsheet.  You can open the excel
object and update that object (out in the excel file) directly using
automation. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Saturday, January 06, 2007 11:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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
> 
> 


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