Selecting and copying data from an AX Table - AX 4.0

Good afternoon all,

I would appreciate all your comments on the following question.

Within the AOT I have a table with approxinmately 90,000 records.

When I select Control+Shift+End button all records are selected but I’m unable to paste the selected data on an Excel 2007 spreadsheet.

In I split the data up into chunks (for example 3 x 30,000 extracts) then I’m able to select, copy and eventually past the data into Excel.

My question is “Does anyone know the extact number of records that can be selected before its no longer to copy and paste the data into Excel or does AX also take into account the number of columns?”

Thanks and kind regards,
Tom