inserting csv - solved, but more to the puzzle

2009-10-16 Thread Patrice Olivier-Wilson
In case anyone might find this of the least interest, probably not, but I always hope to add to discussion just as part of the thank you for help. Further work with same issues found that a file received from a PC based client, if opened in PC environment, didn't have the same problems (so

Re: inserting csv - solved, but more to the puzzle

2009-10-16 Thread Andy Wallace
I've run into similar situations w/regard to Mac vs PC CSV files, it usually has to do with the EOL character sequence. Macs use LF (chr(10)), while PCs use CRLF (chr(13)chr(10)). andy Patrice Olivier-Wilson wrote: In case anyone might find this of the least interest, probably not, but I

Re: inserting csv - solved, but more to the puzzle

2009-10-16 Thread Patrice Olivier-Wilson
Thank you for the confirmation, Andy. I appreciate your patience with such a newbie who is just trying to learn. Andy Wallace wrote: I've run into similar situations w/regard to Mac vs PC CSV files, it usually has to do with the EOL character sequence. Macs use LF (chr(10)), while PCs use