Search results

I am sorry I think I made my statements unclear, that was not what I meant about importing lets forget that one. Would you help me explain this : " it merely severs Access' connection to the spreadsheet so the lock is removed " How can you achieve this ? do you have some steps ? Thanks

Deleting the Linked table is also not an option as there are a number of Calculated fields in the table and after I perform different operations on Table I use Refreshh All and it replicates my changes in the linked Excel. I guess deleting would not work with this case. I was now thinking...

Thank you for the reply Pat. I know even I want to go with option 2 but requirement is like that. What exactly do you mean by deleting the link ? In access ? or you mean the excel file ? Wouldn't that involve a lot of time in linking and deleting again and again. Thanks

I am so sorry for this late reply , I was out of country for a transition. To answer your questions : -Mechanism to connect to DB tables : Link to the Data source by creating a Linked Table - Due to some problems I faced I restricted it to One worksheet per workbook. -Yes, and that is...

Hello, I have an Access Database where several excel workbooks are linked to MS access as Tables basically for the ease of use, when new data is fetched gets updated into access by Refresh. The problem is when the database is open by another user , the excel sheet can not be updated. Is it...