Results 1 to 2 of 2
  1. #1
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Providence, RI

    Cannot export query/table

    I am getting error 3011 when trying to export a table or query (any table or query - I've tried just about every one): "Cannot find the object", despite the fact that the object is spelled correctly and exists. This is happening for local tables/queries as well as passthrough queries and linked tables.

    The code is fairly simple (although I get the same error message when I try to use the export wizard, so I'm sure the code isn't the problem

    DoCmd.TransferSpreadsheet acExport, , "CVDataQ", CurrentProject.Path & "\reports\templates\CurrentVendorTotalsbyYearQ.xlsx"
    Click image for larger version. 

Name:	export error.jpg 
Views:	18 
Size:	86.2 KB 
ID:	38673

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    The message provided is likely not the true cause of error. There could be any of a wide range of causes. Evidenced by web search of this error.

    When will 1 ever equal 0? Should that be: i = 0?
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. How to reverse export of multi-table query to txt file
    By Abacus1234 in forum Import/Export Data
    Replies: 8
    Last Post: 08-28-2017, 04:36 PM
  2. Replies: 2
    Last Post: 08-11-2015, 12:46 PM
  3. Combine Crosstab query with Table to export together to Excel
    By kattatonic1 in forum Database Design
    Replies: 3
    Last Post: 04-04-2014, 10:56 AM
  4. Replies: 1
    Last Post: 12-18-2011, 01:28 AM
  5. Export Query/Table to PowerPoint Graph
    By BED in forum Import/Export Data
    Replies: 0
    Last Post: 03-10-2011, 12:27 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 - Senior Forums