Results 1 to 6 of 6
  1. #1
    hoppop77 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2020
    Posts
    3

    Exporting Data Access 2013 Windows 10


    I am attempting to export data but I am getting this error message saying Object 'tempAgency' already exists. Any help would be much appreciated.

    Thanks!

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That's not a lot of info. The simplest answer is that "tempAgency" already exists, but what is it? A spreadsheet? A view or some other member of a collection? A property?
    You are exporting via ADO code?
    ??
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    hoppop77 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2020
    Posts
    3
    I apologize but I am not savvy with Access.

    I am exporting a list of names which gets generated into a text file along with one other text file named agency.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You didn't answer what tempAgency is so I'm going to guess it's a file and your export is telling you that the file already exists when you try to run it. If you deleted that file, it would probably work just once. If not, you can always post the export code or zip a copy of the db and post it here.

    Even if you don't know Access, you can probably read and answer questions, yes? That is always a good habit to adopt in a forum because the purpose of the questions is to narrow down the possibilities.

  5. #5
    hoppop77 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2020
    Posts
    3
    I am not 100% sure if tempAgency is the agency text file.

    I've already attempted to search for tempagency and could not locate it as I was going to delete the file.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Then I have no idea, based on the limited information. As I stated, you have the option to post relevant code or a db copy. I think that's the only way progress can be made.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-23-2019, 03:31 PM
  2. Replies: 1
    Last Post: 05-11-2018, 10:11 AM
  3. Replies: 4
    Last Post: 09-14-2015, 06:41 PM
  4. Office 2013 and Windows Vista
    By azhar2006 in forum Access
    Replies: 1
    Last Post: 01-28-2014, 04:00 PM
  5. Replies: 7
    Last Post: 04-22-2013, 02:49 PM

Tags for this Thread

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