View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Martin
 
Posts: n/a
Default How to return more data than will fit on a worksheet

Oleg wrote:
How to return more data than will fit on a worksheet.
For example, I need to import 170000 rows from MS Access to MS Excel



1) Import it in two chunks to two or more sheets, or

2) import it in two chunks to two or more different columns in one sheet, or

3) find another spreadsheet program that will hold more rows and still talk with
MS Access.

Bill