Link Tables - Guidance

[101287]

I have MS Access 2002. I link an excel spreadsheet to acces but when I tried to changes fields it's "Read Only".

Is there any way that I can link the table and have update capabilities. Based on a book that I read I should be able to update the spreadsheet from access. I'm sure I'm missing something.

Your suggestions and/or advise will be appreciated.

Thank you for your help.

Luis

 

[101287]

Access is not able to update link Excel table according to Microsoft;

http://support.microsoft.com/?kbid=904953

 

[PWise]

instead of a linked Table Create a query with this Sql

SELECT worksheetname.*
FROM [excel 8.0;imex=0;DATABASE=path\folder\workbookname.xls].worksheetname;