For some reason, I always have to transpose the data to get things formatted correctly using something like this:
TempDataTable = DataRecordSet.GetRows';
Now my question is if there is any way to change the format of the data when I execute the SQL statement? TempDataTable is always in a cell array format (which is fine) but is there a way to maybe change it to a dataset (Statistics toolbox)? I can't seem to find any documentation on changing properties specifically. And yes I have been looking extensively on the mathworks website (http://www.mathworks.com/help/matlab/using-com-objects-in-matlab.html).
Lastly, I have been having trouble reading dates. Blank dates are always being read as NaN instead of just blank (''). I know that the database toolbox has a command called setdbprefs which allows you to change properties such as NullStringRead which is exactly what I want to do but using COM Objects. So, is there a way to change the way NULL data is being read between MatLab and SQL Server?