Richard Korts
asked on
Microsoft Access Export Limit
It appears that MS Access 2002 limits the size of an exported table (to Excel) to 65,536 rows.
Is there a way to overcome this?
Thanks
Access-vers.jpg
Is there a way to overcome this?
Thanks
Access-vers.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@rkorts
Your accepted solution may not be correct. Although older versions of Excel have the 64K limit, if you need to expert Access2003 rows to an Excel 2007 worksheet, you can get around the Access limitation (not, in this scenario, an Excel limitation).
Your accepted solution may not be correct. Although older versions of Excel have the 64K limit, if you need to expert Access2003 rows to an Excel 2007 worksheet, you can get around the Access limitation (not, in this scenario, an Excel limitation).
I recommend instantiating an ADO recordset object, instantiating an Excel automation object and then using the CopyFromRecordset method to transfer the data from Access to Excel.
There are other methods that I show in my article:
Fast Data Push to Excel: http:A_2253.html