Docmd.OutputTo export record Limit?

[Crowley16]

Hi everyone...

I've got some code to output the results from a stored procedure to a excel file, everything works fine.

however I've recently noticed that the results exported are being cut off.

I've checked that the correct number of results are being returned, and recieved at the front end.

So, the only candidate is the OutputTo command.

Is there a limit on the amount of records I can output using this?

My code is like:

      DoCmd.OutputTo _
         acOutputStoredProcedure, _
         "EXEC SPROC_NAME Conditions", _
         acFormatXLS, _
         FileToSave, _
         True

Thanks Guys/Gals

--------------------
Procrastinate Now!

 

[PHV]

Before XL2007 the max number of rows was 65536.
For earlier versions: 32768 and even 16384 (I think) for old versions of Excel.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Crowley16]

the number of rows being written to the output is 1828 and number of rows that's actually there is 2216.

both way short of the max rowlimit on excel...

--------------------
Procrastinate Now!