Gustav Brock
Gustav at cactus.dk
Fri Mar 3 04:21:20 CST 2006
Hi Rocky You can still link and reading is possible but update and append will be disabled. /gustav >>> jwcolby at ColbyConsulting.com 03-03-2006 05:18 >>> I think the issue is specifically that linking spreadsheets has been disabled. If you use automation then you don't have an issue. IO know that because I am using automation (successfully) myself. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, March 02, 2006 7:43 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access and Excel issue Dear List: According to this: http://winks.office-watch.com/9/templates/feat.aspx?articleid=7&zoneid=2 <http://winks.office-watch.com/9/templates/feat.aspx?articleid=7&zoneid=2> Some of the functionality between Access and Excel is disabled in 2002 and 2003 SP2. I have a client where I create a rather elaborate worksheet from a template in Access and push data out to the Excel worksheet, then open it up for editing. When the worksheet is saved, I have a lot of code behind the worksheet that pushes the data back into the Access tables. The worksheets are not linked however. I use automation to do the data transfers. Am I in trouble here or did I inadvertently dodge this bullet? The article refers to linked tables and spreadsheets. TIA Rocky