tomlev1997 Posted January 19, 2021 Report Share Posted January 19, 2021 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. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Flex727 Posted January 19, 2021 MVP 2023 Report Share Posted January 19, 2021 Did you try copy and paste into a blank spreadsheet? Quote Link to comment Share on other sites More sharing options...
tomlev1997 Posted January 19, 2021 Author Report Share Posted January 19, 2021 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 Quote Link to comment Share on other sites More sharing options...
MVP 2023 Flex727 Posted January 19, 2021 MVP 2023 Report Share Posted January 19, 2021 Did you try half or a quarter of the rows at a time? Quote Link to comment Share on other sites More sharing options...
tomlev1997 Posted January 20, 2021 Author Report Share Posted January 20, 2021 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). Quote Link to comment Share on other sites More sharing options...
AlexUT Posted January 20, 2021 Report Share Posted January 20, 2021 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. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.