in reply to Re^2: Problem uploading 'large' CSV file using DBI
in thread Problem uploading 'large' CSV file using DBI

Perhaps your line endings aren't Mac-ish like \r. Perhaps they're UNIXy like \n or DOSish like \r\n.
  • Comment on Re^3: Problem uploading 'large' CSV file using DBI

Replies are listed 'Best First'.
Re^4: Problem uploading 'large' CSV file using DBI
by Tatnall (Beadle) on Jul 27, 2005 at 14:57 UTC
    I had already tried "\r" and "\r\n", but not "\n". Using "\n" everything loaded straight in to the database flawlessly!!!!!!!

    Thank you so much. Now how do I give points and is there a standard way to show the problem has been solved?

    In addition, is there a simple way to tell what is being used to end a line?