I have a query in Access that I would like to export to Excel. The query contains 169,696 rows. When I export it to Excel, it only exports 65,536 rows. Is there a way to export all 169,696 rows? Thank you for any help you can provide.
Results 1 to 2 of 2
Thread: Export Limitation (2000)
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,109
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-09-07 15:54Export Limitation (2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Silver Lounger
- Join Date
- Aug 2001
- Location
- Frederick, Maryland, USA
- Posts
- 1,783
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-09-07 16:43Re: Export Limitation (2000)
Hi,
An excel worksheet is limited to 65536 rows of data. To export more rows to excel, you would need to run queries to break up the data to smaller subsets and export each set of data separately to excel.
There is a feature in excel that will write data to multiple sheets should the data exceed 65536 rows but at the moment I can't remember how to do it.
HTHGary
