When I export my file there are more entries than I have entered.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting my file as a .csv or .txt (tab delimited) for mail merge in
InDesign. I have entered 54 entries but there ends up being 67 entries when I
merge the file. One field is giving me problems on some entries but I can't
figure it out.
 
I would have to guess that about 13 records have a value in the field that
includes a comma or some special character that Access is seeing as a
delimiter. Maybe the name is stored as "Lastname, firstname".
It may be seeing the comma as a delimiter.
It is probably breaking these into multiple fields.
Look for commas in the field and remove them or save the file to a different
format like XLS instead.
Or something else: If the field is a memo field and has carriage returns in
it, they will bee seen as a (tab) delimiter as well.

Use a query. Add the field in question and in the criteria:
Look for commas:
LIKE "*,*"
Look for extra tabs:
LIKE "*" & Chr(9) & "*"
Look for extra carriage returns
LIKE "*" & Chr(13) & "*"


jmonty
 
Back
Top