Can view but not export UDT file data

[tomlev1997]

Hello all. Hope anyone can help.

I received a UDT file.

It is a large one - about 20MB.

When opening in Data Tables Editor I get a message: exception of type 'System.OutOfMemoryException' was  thrown.

Nonetheless, I can see the data on the screen, and scroll till the end.

However, I cannot  export to csv or xls

Any help will be much appreciated.

Thanks,

E.

[Flex727]

Did you try copy and paste into a blank spreadsheet?

[tomlev1997]

6 hours ago, Flex727 said:

Did you try copy and paste into a blank spreadsheet?

I did...choosing all rows creates an error: Unhandled exception has occurred in your application.....

I have 435600 rows and 12 columns  

[Flex727]

Did you try half or a quarter of the rows at a time?

[tomlev1997]

I did try copying part of the data...it works for small chunks, which means a lot of manual select - copy - paste. I was hoping for another reader that can extract UDT files automatically. The SD Card Manager is from 2009 (version 2.0.66.0).

 

[AlexUT]

Hi,

What Excel version do you have? 32bit or 64bit?

What Windows version do you use? XP, 7, 8.x, 10?

32bit Excel support 64K rows, so you have to use 64bit Excel version which on XP 64bit supporting near 1000000 rows.

 

Other recommendation is to use daily/weekly/monthly files to have relatively small files - number of MB.

Large files make access time wery long.

When there is a failure when big file used, then data may be not recoverable.

Take care that maximum number of SD stored files in folder is 64/60 files.

Store more files will lead to SD catalog corruption.

B.R.