Excel 2003 Limitations?

G

Guest

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!
 
N

Niek Otten

<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 Help>Specifications.
 
D

Doug Kanter

Transam388 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top