May 19, 2015 12:28 PM|Lannie|LINK
If inserting into XLS there is row limitation of 64,000 rows
If inserting into XSLX there is also limitatons. Usually when the dataset is over 1 gig in size, XLSX does not perform so well.
Even MSACCESS has size limitations when trying to insert data.
so you have 500,000 records and who knows how many cols,
you may very well expect out of memory errors.