Download unix2dos.exe (there is also a dos2unix.exe)
http://www.bastet.com/software/UDDU.ZIP
If you are running the php on *nix, and wanting to import the file
on excel, you will need it..
Another thing you can do, is create it in an html/table format
<table>
<tr>
<td>data1</td>
</tr>
....
</table>
this will be read fine by excel regardless of the end of line string.
--
=======================================================================
Michael J. Ryan - tracker1[*at*]theroughnecks.com
Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net
=======================================================================
Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/
"Alfredo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I am saving the result of a query on a text file. Then I want to open it
> with excel.
>
> At the moment, when I open it with excel, all results appear in one very
> long line. How could I insert a "new line" character at the end of each
> record?
>
> Thanks
>
> Alfredo
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
