Trouble with Data Merge in InDesign CS5: We have a word doc that was created, then each appropriate section was cut and pasted into an excel file. When the Excel file is saved as a csv file and imported, the file unexpectedly stops, not completing its flow into the appropriate data fields. We are thinking that it is because of some unknown "special/hidden" characters within the original Word file. Is this a correct assumption, and if so is there a way to show those characters in order to eliminate them? (we did not create the word doc originally)
Or, is there another way that we can accomplish what we are trying to accomplish, which is to flow text from a database into an InDesign template?
I'd start by opening the .csv file in a plain text editor and taking a good look at it to make sure each record has the same number of fields (commas) and there are no obvious special character problems. Then resave from there as plain text with the .csv extension.