T TJBernard Registered User. Local time Today, 08:04 Joined Mar 28, 2002 Messages 176 May 23, 2005 #1 I have a .csv (MS Excel) file I need to import, but one of the fields contains rich text format text. Is there anyway to clean this up before or after it is imported? Thanks, T.J.
I have a .csv (MS Excel) file I need to import, but one of the fields contains rich text format text. Is there anyway to clean this up before or after it is imported? Thanks, T.J.
P Pat Hartman Super Moderator Staff member Local time Today, 03:04 Joined Feb 19, 2002 Messages 46,962 May 23, 2005 #2 Are the RTF tags actually being imported? If they are, you'll need to clean up the column in Excel by saving the column as plain text.
Are the RTF tags actually being imported? If they are, you'll need to clean up the column in Excel by saving the column as plain text.
T TJBernard Registered User. Local time Today, 08:04 Joined Mar 28, 2002 Messages 176 May 23, 2005 #3 Pat Hartman said: Are the RTF tags actually being imported? If they are, you'll need to clean up the column in Excel by saving the column as plain text. Click to expand... Yes, the actual RTF tags are importing into MS Access.
Pat Hartman said: Are the RTF tags actually being imported? If they are, you'll need to clean up the column in Excel by saving the column as plain text. Click to expand... Yes, the actual RTF tags are importing into MS Access.
