how to rremove ascii characters imported into access from excel?

S

Steve

When I import data from Excel into Access, I get a box shaped charcter
fromthe Excel data representing the ALT + CR. ( This adds a line in a text
based cell)
Seems like the onlu way to fix it is to manually edit every instance.
There should be a better way????
 
T

Tom Collins

You can run an update query.

Use something like this:
UPDATE Table1 SET Field1 = Replace([Field1 ],Chr(13),"")

Tom Collins


| When I import data from Excel into Access, I get a box shaped
charcter
| fromthe Excel data representing the ALT + CR. ( This adds a line in
a text
| based cell)
| Seems like the onlu way to fix it is to manually edit every
instance.
| There should be a better way????
 
Top