Linked Excel sheet wont allow me to update via tbl (Access@003 SP2)

[patt]

I have linked a spreadsheet to access and cannot change data in datasheet view of the table.

I need to update the sheet via VBA. I have gone for the linked table approach rather than Excel Austomatio. is either way better than the other?

[HansV]

Lined Excel tables cannot be updated. This used to be possible in the past, but Microsoft lost a lawsuit over the use of the technology behind it, and disabled the feature sometime in 2005. See 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.

You can use Automation to update the workbook.

[patt]

I figured it was not allowable in later versions as i am sure it used to work in Access 2000.

Thanks Hans.