Excel query using Transfer Data from System i

[mikjall77]

I am looking for information on how I can use the Transfer Data from System i Add-In for Excel to only get data that equals the data in one of my columns (both sets of data are strings). Unfortunately, I cannot just get the entire contents of the System i table since it contains more than the maximum allowed in Excel. Thank you!

 

[Derek Brown]

Hello and welcome to The Board.
I assume that by "System i" you are referring to an IBM iSeries machine.
You did not say which version of Excel is being used.
If 2007/2010 you have about 1.1 million rows - is that what is being exceeded?
If using 2010 you could consider using PowerPivot to access the data.