DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Jul 18 16:09:36 CDT 2006
The Replace() function?? Drew -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: Tuesday, July 18, 2006 3:59 PM To: accessd at databaseadvisors.com Subject: [AccessD] Import Large delimited file with special characters Hello All, I've been back and forth with this issue. I think some here helped me with this years ago. Importing a large delimited text file...that has a text/memo/blob field. I'm running into CR or LF in the blob. Is there a way to remove these characters...I seem to remember someone telling a way to loop through and replace these characters...but I can't find it. Any have ideas? Thanks, Mark -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com