I am attempting to export a somewhat large Access 2013 table to a delimited text file, with the intention of using the file to load an ORACLE table, but sometimes, it acts like there was a "data hiccup" of some sort that causes a rows to appear to be left or right shifted. I thought perhaps it was caused by a field containing the delimiter and throwing things off-kilter but the rows after it are fine. Further investigation seems to indicate there was an EoL char in the previous row, making it split a row in the table into two records in the data file. I discovered that if I edit the file in notepad and remove the line break, it usually fixes the row, but not always. Odder yet, this behavior isn't consistent. Is anyone aware of what would cause this to happen?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.