View Single Post
  #1 (permalink)  
Old February 25th, 2006, 01:05 AM
Renee Voice Renee Voice is offline
Registered User
Join Date: Feb 2006
Location: Sydney, NSW, Australia.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Outputto exceeded limit of rows

I have used the docmd.outputto command to export a query into Excel and have got the error message which states that the limit of Access or the OutputTo command has been exceeded. Does anyone know what the limit is and how to overcome it. There are 21095 rows to be exported. Here is a sample of the code:

Set qdfNew = CurrentDb.CreateQueryDef("NewQueryDef", _
                "SELECT * FROM [Adviser Flows - Holdings] WHERE [DbaseMngr] like '" & strFundMngr & "*'" _
                & "union all SELECT * FROM [ADVISER FLOWS - HOLDINGS Essentials Funds] WHERE [DbaseMngr] like '" & strFundMngr & "*'")
          'If there are records for the Fund Manager the data is exported into the Excel file
          If DCount("[DbaseMngr]", "NewQueryDef") <> 0 Then
                        StatusBar "The " & strFileNme & " is being created...."
            DoCmd.OutputTo acOutputQuery, "NewQueryDef", acFormatXLS, strPth & strFileNme

I would really appreciate any help you can give me.