Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: UTL_FILE QUESTION
In article <jFrW6.12350$A45.1259024_at_news2-win.server.ntlworld.com>, "Richard
says...
>
>
> Hi
>
>I am trying to copy lots of records from the dbase to a UTL_FILE on the
>server. My problem lies in the number of records retrieved and the file
>name. As the file has to be imported into excel after, I have to limit the
>records in each file to < 50000.
>
see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:728625409049
that shows a method that uses the SYLK file format to write files for excel and other spreadsheets. It might avoid the 50k limit you are hitting with excel and gives you much better abilities to format the data (fonts, bolding, even formula's).
>does any know if there is anyway way of using some sort of sequence
>alphabetically, as I can't use numbers in the file name?
>
> i.e filename = group||file_name
>
> where file name = AA for the 1st file
> then AB and so on
>
>
> or is there way of formatting the UTL_FILE in such a way as to avoid the
>Excel import wizard?
>
> Any help appreciated.
>
> Thanks
>
> Richard
>
>
>
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/ Oracle Magazine: http://www.oracle.com/oramag Opinions are mine and do not necessarily reflect those of Oracle Corp Received on Fri Jun 15 2001 - 13:52:04 CDT