[AccessD] OT: Max rows in Excel 97

Drew Wutka DWUTKA at marlow.com
Thu Mar 6 16:19:00 CST 2003


http://support.microsoft.com/default.aspx?scid=kb;en-us;167669

The link above explains the 16k limit.

It also has a work around. 

Drew

-----Original Message-----
From: t tom [mailto:ttom at accessyourdata.com]
Sent: Thursday, March 06, 2003 4:03 PM
To: accessd at databaseadvisors.com
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



More information about the AccessD mailing list