Linq or SQL processing of SPSS file

Nov 11, 2011 at 3:52 PM

I Have a huge SPSS file with 10000 columns and 10000 Rows and with each column having value labels at an average of 100.

I would like to process this file such as removing all string variables, date time variables -removing all but numerical variables ,adding value labels if any are missing, Changing negative numbers to blank. and so on

What is the best way to process this file : Using Linq or loading data into SQL and then process?

Need fast and optimized solution. I am using Library from here: http://www.codeplex.com/spss.

 

Thanks in Advance.

 

Sree