Results 1 to 5 of 5
  1. #1
    jccdlc is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2019
    Posts
    3

    ExportWithFormatting 65,536 maximum rows

    I have a macro in Access and am using the ExportWithFormatting command



    Even though I have this set for .xlsx , the macro will only export 65,536 rows
    Is there some other setting in Access that is preventing this from going past the 65,536 row limit? When I export this query manually it works fine.
    Any help would be greatly appreciated.
    Thank you

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The newer versions of Access should export all records.
    instead of that command, try using
    ImportExportSpreadsheet,

  3. #3
    jccdlc is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2019
    Posts
    3
    Thank you for responding.

    For some reason that command is not showing up in my list. I am running Office 365
    Click image for larger version. 

Name:	Untitled.jpg 
Views:	8 
Size:	36.8 KB 
ID:	37813

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the default is a limited list, so you must click SHOW ALL ACTIONS button on toolbar to sell all commands.

  5. #5
    jccdlc is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2019
    Posts
    3
    That got it.

    Thank you for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-07-2018, 01:53 PM
  2. ExportWithFormatting using Excel 2007?!
    By accessmatt in forum Macros
    Replies: 9
    Last Post: 11-06-2014, 10:00 AM
  3. Replies: 2
    Last Post: 07-13-2014, 07:32 AM
  4. ExportWithFormatting Error
    By voro in forum Import/Export Data
    Replies: 3
    Last Post: 10-29-2012, 09:29 AM
  5. Replies: 0
    Last Post: 02-09-2012, 05:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums