Getting Rid of @ in Linked Excel Table

Learn2010

Registered User.
Local time
Today, 11:55
Joined
Sep 15, 2010
Messages
415
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.
 
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
 
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.
 
For some reason, Access adds the @ sign on text fields. It is a formatting character and doesn't impact anything except formatting.

As CJ said, you can't link to an Excel table and update it via the GUI or a query because MS lost a lawsuit about 10 years ago with some individual who claimed MS stole his technology.

You can import the data, update it, and export it back or if you are comfortable with VBA, you can update using OLE automation if you know specifically what you need to update. This is of course not usable with user interaction but it is useful if you have batch changes to make.
 

Users who are viewing this thread

Back
Top Bottom