converting characters using an update query

[Bryce Dalley]

I need to convert (chr(10)) to a combinatino of (chr(13))
and (chr(10)), so that the spacing from the excel file I'm
using converts over to access. How do I convert something
like this using a query?

 

[Heather]

Try something like this:
replace(myVariable,chr(10),chr(13)||chr(10))