[AccessD] OT: Max rows in Excel 97

Make sure that you are saving the file as 97 and not "Microsoft Excel 97 & 
5.0/95" in the save as box.  If you save it as the later Excel will 
"cut-off" the rows after 16,384.  You could also save your file as a CSV 
file.




"t tom" <ttom at accessyourdata.com>
Sent by: accessd-admin at databaseadvisors.com
03/06/2003 04:02 PM
Please respond to accessd

 
        To:     accessd at databaseadvisors.com
        cc: 
        Subject:        Re: [AccessD]  OT: Max rows in Excel 97


Hi All

What is the maxinum of rows you can import from an Excel file.
I am trying to import an Excel file containing 20,000 rows but it stops at
16,384.

Also , what is the maxinum of records you can export to an Excel file ( 
per
sheet ).


TIA
Tomt

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030306/1d1ffdb5/attachment-0001.html>