Link to Excel to avoid corrupting sheet?

[Gasman]

Hi all,
I've just thought about this and so before I suggest it on Monday, I thought I'd ask advice?

One of the teams in work have started using a shared Excel sheet. Only about 5 people, but it appears to be getting corrupted easily and always thinking that someone has locked it.?

They are *thinking* of moving it to Access, but I was wondering whether just linking to the sheet from Access would be sufficient, as opposed to trying to bring it in to Access and having to create backend DB etc.

Has anyone done this?

TIA

 

[Uncle Gizmo]

But you won't be able to edit the spreadsheet in Access?

https://support.microsoft.com/en-us/kb/904953

You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2007, Office Access 2003, or Access 2002



Sent from my SM-G925F using Tapatalk

 

[Gasman]

Mmm, that is that idea in the bin then.

But you won't be able to edit the spreadsheet in Access?

https://support.microsoft.com/en-us/kb/904953

You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2007, Office Access 2003, or Access 2002



Sent from my SM-G925F using Tapatalk

 

[The_Doc_Man]

Import the sheet to Access to make a table out of it. However, there will of course be a learning curve if the current spreadsheet users are undisciplined in the way they use things.

 

[Gasman]

Thanks The_Doc_Man,

I've left it for now, too many other things to work on, and I *think* they will stop using the workbook in the next few days. If they come back to me, I'll look into it again.