Getting Rid of @ in Linked Excel Table

[Learn2010]

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.

 

[CJ_London]

Not sure which 'that' you are talking about - the query is not updateable or you can't get rid of the @ formatting

If the former, you cannot update an excel file through using queries.

Not sure what you mean by 'table is a text field' is it just one column?

In Excel formatting = @ means formatting = text

Are you trying to bring numbers in? If so, ensure the first row has a number in it and is not blank otherwise Access will assume it is text

 

[Learn2010]

You say you can't update a linked Excel table? If that is true, then I will import it. Also, the that I was speaking of was the @ symbol.

Thanks.