I am running a VBA looping program which opens a query in access and exports
data to different workbooks, this looping process works fine. However one
query exceeds 65536 rows.
Does anyone know how I can code around this to split the data into two
worksheets within the same workbook... or even three worksheets if required.
One suggestion has been to export to text then split the text file, however I
would rather not use this method has the above process is one step in a
number of steps.
I am using the "DoCmd.TransferSpreadsheet ".