I have a select query which produces 66074 records which I manually export. The exported spreadsheet produces 65535 records??? What am I doing wrong. I get the same problem if I export by using VBA or a macro.

I have done this exercise many times before without this type of problem. In fact I have 2 other similar select queries which I have no problems with.

65535 is the maximum number of rows you can have in Excel.

Ah, Um right. I forgot about that. Silly me. Thanks for reminding me. Happy New Year to you BTW.