[AccessD] Excel Linked Table - "Sharing" Problem

All,

Thanks to everyone who shared their ideas and insights on this issue.

I started by experimenting with a test Excel file in order to try a couple different approaches.

Then I tried to use the actual Production Excel file.  When I try to import or link to this file, I receive this message.   

"The wizard is unable to access info in the file H:\Production.xls.  Please check that the file exists and is in the correct format"

Evidently, there is something in the Production Excel file that Access does not like.  I need to get past this hurdle before I move forward.

When time permits, I might experiment with VBA and Windows Automation to get at the Excel file data from Access.

Thanks again for your help.

Brad 




-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Friday, October 03, 2014 8:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Linked Table - "Sharing" Problem

There is a Boolean "MaintainConnection" property which may be related to this.
>From what I understand, it's not available via the GUI......only VBA.
>
> Sure... There are many ways of doing this.  But the key is to 'unlink'
> the live connection between Excel and Access.
>


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com