Print Page - no of Rows limitation on .CSV format

Title: no of Rows limitation on .CSV format
Post by: pooja on 03 Feb 2011 08:53:59 AM

is there any limitation in no of rows while running .CSV format?
if yes, then how many?

thanks in advance

Title: Re: no of Rows limitation on .CSV format
Post by: ksr on 05 Feb 2011 01:10:15 AM

By default, .CSV files are opened in Excel, so even though .CSV files don't have the 65k row limitation, the file will be truncated if it is opened in Excel.

For complete article, please read my article on my blog

http://cognosteacher.blogspot.com/

Title: Re: no of Rows limitation on .CSV format
Post by: holsy1982 on 06 Feb 2011 06:35:03 AM

Though presumably the latest version of excel would allow 1mill records for CSV files as per the new limit.

Though when Cognos is reading in CSV does anyone know if there a limit then?

Title: Re: no of Rows limitation on .CSV format
Post by: ksr on 07 Feb 2011 05:23:02 AM

no limit in the case of .CSV

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 03 Feb 2011 08:53:59 AM