Limitation of DoCmd.OutputTo acOutputQuery

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Denburt
    Recognized Expert Top Contributor
    • Mar 2007
    • 1356

    #16
    It must be an issue with that table then check the data and make sure that the integrity of the table is sound. Verify all lookUps, and check your indexs. Verify that there are no duplicates in fields designated as such and the fields designated as required actually has data. It is possible that I am missing something but beyond this I could only say that it could be corrupted somehow. Maybe you could try it on a different table or different database....

    Comment

    • ChaseCox
      Contributor
      • Nov 2006
      • 293

      #17
      Originally posted by Denburt
      It must be an issue with that table then check the data and make sure that the integrity of the table is sound. Verify all lookUps, and check your indexs. Verify that there are no duplicates in fields designated as such and the fields designated as required actually has data. It is possible that I am missing something but beyond this I could only say that it could be corrupted somehow. Maybe you could try it on a different table or different database....

      thanks for the help. I tried a different in table in the DB, and it exported the exact same number of rows. I will try and figure it out I guess. Thanks for all of your help and time.

      Comment

      • ChaseCox
        Contributor
        • Nov 2006
        • 293

        #18
        UPDATE: I just exported the table in question using saveAs/export command, and I got the same result. So I need to identify the problem being with access or excell.

        Comment

        • Denburt
          Recognized Expert Top Contributor
          • Mar 2007
          • 1356

          #19
          Yep solve that and you should be good to go, I wish I had more suggestions for you to look for but at the moment I can't think of anything that may cause this issue. Good luck and when you figure it out let us know I am curious as to why this could be hapening.

          Comment

          • ChaseCox
            Contributor
            • Nov 2006
            • 293

            #20
            Originally posted by Denburt
            Yep solve that and you should be good to go, I wish I had more suggestions for you to look for but at the moment I can't think of anything that may cause this issue. Good luck and when you figure it out let us know I am curious as to why this could be hapening.

            HOORAY HOORAY:

            I have solved the mystery, I update this line:
            Code:
            DoCmd.TransferSpreadsheet acExport, 8, "Voyager2Table", strFolderName & "\MyFile1", True
            The 8 is what sets the limit to the appropriate 65k limit. I am going from access 97 to excell 2003, which requires that 8 to be there!!!

            Is there a way to prompt the user to change the name of the file before it is saved?

            Comment

            • Denburt
              Recognized Expert Top Contributor
              • Mar 2007
              • 1356

              #21
              Awesome glad you found it.


              Code:
              DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Version", strFolderName & "\" & InputBox("Pop"), True

              Comment

              • Denburt
                Recognized Expert Top Contributor
                • Mar 2007
                • 1356

                #22
                Change POP to the message you want displayed. :) Sry

                Comment

                • ChaseCox
                  Contributor
                  • Nov 2006
                  • 293

                  #23
                  Thanks, Everything is looking tip-top!

                  Comment

                  • Denburt
                    Recognized Expert Top Contributor
                    • Mar 2007
                    • 1356

                    #24
                    Awesome! Glad to know that everything is working.

                    Comment

                    Working...