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

    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



    Code:
    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
    Location
    The Great Land
    Posts
    52,815
    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.

    https://www.mrexcel.com/forum/micros...readsheet.html

    https://stackoverflow.com/questions/...k-at-column-iv

    When will 1 ever equal 0? Should that be: i = 0?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 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