Jump to content

Can view but not export UDT file data


tomlev1997

Recommended Posts

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.

Link to comment
Share on other sites

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.

 

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This site uses cookies. By clicking I accept, you agree to their use.