Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Transam388
 
Posts: n/a
Default Excel 2003 Limitations?

Is there a maximum file size for Excel 2003 and or other limitations on the
amount of rows / data that it can store? We have an application that is
trying to automatically import roughly 132,000 records into an excel file and
only 16+ thousand are shown. Any ideas? Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Excel 2003 Limitations?

<only 16+ thousand are shown

Is a record a row?

Excel has a limit of 65536 rows per worksheet.
You can use more worksheets, but that generally doesn't make things easier.
Check HelpSpecifications.

--
Kind regards,

Niek Otten

"Transam388" wrote in message
...
Is there a maximum file size for Excel 2003 and or other limitations on
the
amount of rows / data that it can store? We have an application that is
trying to automatically import roughly 132,000 records into an excel file
and
only 16+ thousand are shown. Any ideas? Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Excel 2003 Limitations?


"Transam388" wrote in message
...
Is there a maximum file size for Excel 2003 and or other limitations on
the
amount of rows / data that it can store? We have an application that is
trying to automatically import roughly 132,000 records into an excel file
and
only 16+ thousand are shown. Any ideas? Thanks!


Start learning to use Access instead of Excel.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2003 row height format Moises Colin Excel Discussion (Misc queries) 0 October 25th 05 06:35 PM
Very slow in opening Excel 97 file in Excel 2003 S M Setting up and Configuration of Excel 0 October 22nd 05 07:32 PM
Excel Re-calculation 2000 compared to 2003 tonymitchell Excel Discussion (Misc queries) 1 August 3rd 05 04:22 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM


All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"