Results 1 to 8 of 8
  1. #1
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33

    Cannot Export to Microsoft Excess

    Good morning, I was made aware yesterday that there is a problem with exporting to Excel from Access 365. I get this error. Since I am using the ribbon to select Excel as the format, I'm not sure where to go from here. I have compiled all the code, done a Compact and Repair and of course restarted it. If anyone has an idea of what is going on, I would appreciate the help. OH! and I can export the information in any other format except Excel.
    Thanks again for any help!


    Click image for larger version. 

Name:	ExcelErrorInAccess 2022-07-26 080627.png 
Views:	16 
Size:	20.3 KB 
ID:	48374

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    5,010
    Have you tried a Repair first?
    Then setup as it advises?
    I have no idea as to why it mentions a workgroup file. Are you actually using one?, or is that just a very old error message, never updated

    MS have been making a good few mistakes with Access in the last few weeks, so that is always a thought as well, but others should be reporting that as well?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,992
    I like the idea of combining Excel & Access into Excess

    BTW there was an issue with exporting in a recent 365 update but it has been fixed in version 2206 build 15330.20264

    See https://support.microsoft.com/en-us/...a-dfe964294a81
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    I did do the Repair, no change. As for the set up, I'm not sure where that would be. Since I am working on laptop that is owned by the company, there are a few things I can't do.
    Can you tell me where the "setup" is?

  5. #5
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    Can you help with looking up the version and build? Not sure where to find those.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,821
    I believe that from the ribbon, it's in File under Account > About Access.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    Looks like my third party manager is a bit behind. I have Version 2108 (Build 14326.21062). I'm going to see if I can bet it to update and see if that takes care of it.

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,821
    I don't know if they fixed the last thing they broke in the last update. I'm stuck on 2205, having disabled updating. I'd look into known version bugs and see if you can upgrade to something less than the latest (which I think is 2206).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 5
    Last Post: 06-02-2022, 03:39 PM
  2. Export Microsoft Query with Picture Fields to a Word Document
    By KSReynolds in forum Import/Export Data
    Replies: 2
    Last Post: 10-15-2013, 02:36 PM
  3. Replies: 1
    Last Post: 09-13-2011, 01:52 PM
  4. Excess Resource (MSDB)
    By mei909 in forum Programming
    Replies: 1
    Last Post: 09-04-2011, 12:15 AM
  5. Export table from Oracle to Microsoft Access 2007
    By dba in forum Import/Export Data
    Replies: 1
    Last Post: 02-25-2011, 07:05 AM

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