DevDB (4/11/2013)
Look for the line breaks in the export. That will cause the difference in count.
excellent point, something like this would be five rows in a text editor, but one row of data, if the row terminator was \n or some other custom terminator
'A string{cr}
with Carriage Returns{cr}
that finally ends {cr}
with a{cr}
{cr}{lf}'
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!