>I had to import a text file which has pipes as the delimiter. When I use APPEND FROM DELIMITED WITH | I get a bunch of records with blank fields. I went into Modi file and replaced all the pipes with commas. Then I reissued the append command as "Append from type delimited", and the data came over into the table with no problem. Does anyone have any idea why this might have happened? > >Sylvia
I've never had success using the | as a delimiter.
Craig Berntson MCSD, Microsoft .Net MVP, Grape City Community Influencer