View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Sean is offline
external usenet poster
 
Posts: 208
Default Row limit on external data in Excel 2007

I can only get 65,356 rows when I link Excel to an external data source. I am
using an ODBC driver to link to an IBM i-series database (AS400). The
database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+. Is
there different limit for linked tables?