Misalignement in Excel sheet,while downloading reports with huge data

[Former Member]

Hi,

While downloading reports in excel with huge volume of data ,we are getting misalignments in the excel sheet(some data comes in wrong rows). Can you please suggest what could be the reason and how to correct it.

Regards,

Roopak

[former_member183879]

Hi,

If you are using Office 2003, then you cannot download morethan 65000+. However if you use Office 2007, I think it gives you somewhere around 400000 records. (I didnt scroll below that!!!). Also the columns are morethan IV.

However assuming that, even that version can have limitation, you can always download your data in a wordpad/notepad/textpad etc which are basically text editing tools. They dont have any such row or column restrictions.

Once downloaded, you can randomly split them into some x number of files, based on the number of records and then open the same documents using xls sheet using tab value as delimiter. Now the alignment will be perfect in the excel sheet.

[Former Member]

The maximum limitation of cells of excel is 65536 row,if your data exceeds it, you would need to download it to txt file first and upload it to Access,hope it helps.

[Former Member]

Hi Klaas,

The no. of rows downloaded are 68740 and the mislalignment problem is in 10142th ,10143rd row.Kindly suggest.

Thanks,

Roopak