I have a macro in Access and am using the ExportWithFormatting command
Even though I have this set for .xlsx , the macro will only export 65,536 rows
Is there some other setting in Access that is preventing this from going past the 65,536 row limit? When I export this query manually it works fine.
Any help would be greatly appreciated.
Thank you