[AccessD] Import Large delimited file with special character s

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



More information about the AccessD mailing list