• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1340
  • Last Modified:

iSeries Data Transfer to Excel 2007 limits rows

I am extracting data through Excel 2007 using iSeries Client Access transfer. However, even though I have Excel 2007 with 1 million rows, it stops at 65636 and says rows beyond are not valid. It will not let me start at a new row beyond that either. Is there a newer version of Client Access or a way around this?
0
Jeremy_Neppl
Asked:
Jeremy_Neppl
  • 2
  • 2
2 Solutions
 
JBart_17Commented:
Its not excel that is the limitation it is the dtf. its newest excel format I belive is excel8 (excel 97)
use a ODBC connection and a query
let me know if you need help setting it up
0
 
Jeremy_NepplAuthor Commented:
Is there any way I can set relationships this way? Or limit the query. I don't want all million records, just some of them.
0
 
JBart_17Commented:
if you want to use the dtf. you need to filter the records on something to limit the result
In the *.dtf click "Data Options"  and in the "Where" section put in how you want to filter it you will need to know the name of the field. remember the if the field is a string you will need the single quote around your value
example: year=2008,NAME = 'John Smith'
0
 
tliottaCommented:
Jeremy_Neppl:

You might try specifying a BIFF7 or 8 output format in the .DTF in order to go past the 65K row limitation. This may cause multiple worksheets to be created.

Other than that, it looks like the others have already given proper answers.

Tom
0
 
Jeremy_NepplAuthor Commented:
Thanks for the help!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now