I'm having a data transfer issue. I get the CWBTF0012 general error. Looking it up it say reached max records. Here is the strange thing, I'm still under that number of records. According to what I have seen it relates to Excel 2007. I am currently using Excel 2010. I do have the client access plugin. If I run my SQL statement for the data it returns 42,272 rows. If I go into the data transfer add in, and try to run the same native SQL to retrieve the data I get the error and it stops at row 17,305. Any ideas? The only reason I try an do the data transfer as a SQL is it formats into Excel better than doing a cut and paste. Pastind tends to screw up date and field that are alpha but contain only numerics (it drops all leading zeros).
Software/Hardware used: Excel 2010, and i-series level V7R1M0