[MS_AccessPros] How can I replace CRLF (with space) in thousands of Memo and Text fields in many tables in a database?

 

These may have multiple CRLF within cells, along with other sentences, without losing the sentences.  Need having it all on one line with one space instead of CRLF, as exporting to text file and importing to Oracle.  Access 2003, & Access 2010 is available. 

Example:

MEMOfield         TEXTfield

John Doe             Likes summer.

123 Main              Also like winter.

AnyCity,MN      

Other tables may only have CRLF in either Memofield or Textfield.  I've been away from VBA for a while.

Thanks in advance for any help  - Mark

 

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___