Unanswered: Exporting Access Tables to Excel(Please help!)
Please need help,
I am trying to copy large amount of Data well over 65535 lines from Access's table to Excel via VBA. Since the max number of rows in excel sheet is 65536, how can I transfer the data? Is it possible to use DoCmd.Transferspreadsheet and transfer 65535 lines at a time on each loop iteration till the .RecordCount has reached eof and transfer each of 65535 lines to new .Worksheet(i)?
Please if you have any advice I greatly appreciate.
Something I noted a while back: if you Create and Excel object in code, then release the object but don't close Excel, you may get an error later when the user finally closes Excel. It's a quirk, but I make sure it never happens by requiring the user to have Excel open before running the code and using GetObject instead of CreateObject. I don't know if they fixed this in 2K and newer.