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

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)?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ignoring format/control codes exporting data from access to excel 21
How do I remove all tabs from word document 3
How do I remove "special characters" from cell data? 3
Handling embedded Carraige return/ line feeds 1
how do i increase form cell lenth from 50 to 200 plus characters 4
How do you import postal codes from Excel to Access 5
How do I display nonprintable characters 1
how do i sort? 8

Top