I need to import .csv files into Access, so I make sure there are no commas or manual line breaks in the data. But there’s one file that’s weird. When I import it into Access, some fields have double-quotes around their contents. Unlike a comma or manual line break, this does not result in the data being split into separate cells, shifting data to the right. When I export as fixed-position text though, the cells are expanded and the data is shifted.
All I can think of is that there’s some sort of bizarre non-display character there that I’ve never heard of. Does anyone know what it is?
When I’m in the office, I get rid of manual line breaks by replacing ALT+010 with pipes. At home I copy the file to Word and replace manual line breaks with pipes. So if anyone can give me a clue as to what the ALT code is, and also what it’s called in Word, that would be great.