Linking of Excel sheets in SharePoint directly to MS Access

[PGL]

I have a number of Excel spreadsheets (data sources) hosted on Sharepoint that I need to link to one single Access database.

At first. I cannot link the spreadsheets directly to Access because Access cannot read the spreadsheets on SharePoint to make the links.

Secondly, I can export the spreadsheets from SharePoint to a local folder on my PC and keep them 'refreshed'. The problem with this is that I cannot link Access to the local refreshed spreadsheets because of the (auto) extention .iqy. Access does not know the extention .iqy and hence the two cannot be linked at all.

Thus: How do I link an Excel spreadsheet hosted on SharePoint to MS Access.

Please help (urgently).

Appreciate
PG

 

[PGL]

Thank you Pat,

Scenario 1: Access cannot copy the sheets from SharePoint. BUT, SP can export the sheets to a local hard drive effectively and keep it 'mirrored'. The problem here is that the exported sheet's extention is .iqy and Access does not recognised it.

Scenario 2: I can try this but I'm not up to par with SP Lists. Why is it called lists? I am going to try this route and see what happens.