CalEvans wrote on Mar 14 2004, 08:43 PM:
I have about the same problem as the previous user… but the nl solution doesn't work… neither does n or l or nr or AUTO or any of my other attempts to snag this by trial and error.
PSPAD says the records in my file end with hex B6 which they call ¶. My table is large, so I am using WINRAR, but the database doesn't seem to have a problems with that. It also has no trouble restoring an entire database created the same way, or a smaller single table non-compressed table also created by the same software. I'm running out of ideas… and shudder at the though of splitting the table into 6 or 7 noncompressed chunks… ugh! Any thoughts? Is there any documentation for the corect way to enter the line control parameters into the box (abbreviations, hex codes, actual characters?) Oh, I also tried putting a ; at the end of each line and entering that in the line termination box… result was too many fields in first record error message.
