John Colby
jwcolby at ColbyConsulting.com
Fri Jan 6 13:20:15 CST 2006
Yea, I already have automation figured out (I think). John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, January 06, 2006 1:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can't write to an Excel spreadsheet There's always Automation though. More effort, but it works. See http://support.microsoft.com/default.aspx?scid=kb;en-us;302460 for a recent help file on the subject. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Friday, January 06, 2006 12:47 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can't write to an Excel spreadsheet Oh yea, I remember. What a PITA. That throws a major wrench in the works. I was hoping to open a predefined spreadsheet, with locked columns, named ranges etc., then just export data to it, attach to an email and send. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, January 06, 2006 12:41 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can't write to an Excel spreadsheet There were a couple of threads on this a few weeks ago. Apparently M$ lost some law suit and the end result was they had to disable the ability of Access to update Excel. You can still export to Excel, but that's it - I think. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Friday, January 06, 2006 12:30 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Can't write to an Excel spreadsheet I created a spreadsheet in a workbook. Placed text names in the top row for four columns, saved the sheet. I then linked the sheet to Access. With no data in the spreadsheet, the table shows no data, and there is no new record row. If I try to append data to Columns A and B using an append query, I get a "you are using a non-updateable query" or something similar. If I name a range and link to the named range, with actual data in a few records, the entire range shows, the data shows in the first few rows, but the whole thing is non-updateable. I thought that an Excel spreadsheet was updateable from Access. Am I doing something wrong or is Excel indeed not updateable from Access? John W. Colby www.ColbyConsulting.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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com