I have a linked Excel table in Access. I ran a query against it and it said it was not updateable. I checked the table and found that in design view, the table is a text field and in the Format box is an @ symbol. I can't get rid of it. I tried going to the Excel file and reset the format of the field to "Text," relinking it, deleting it, and still it won't go away.
Does anybody know how to handle that?
Thank you.
Does anybody know how to handle that?
Thank you.