How do I remove control characters (eg CRLF) from access files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to load excel files into access but the data contains control
characters like line feeds. When loaded to Access they send the data
formatting out. Is there a way to strip out control characters from a data
file (whilt leaving other characters, numeric, alpha and standard punctuation
in)?
 
Find a list of ASCII character representations.
You can use the Asc function to translate the characters to a numeric value.
For example, a space is 32 (Asc(" ") = 32).
Write a function that evaluates the value of a field character by character
and omits the character from the field.
 
Back
Top