Results 1 to 2 of 2
  1. #1
    Seamus59 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    34

    Invalid bracketing of name of external database as source dbf used in append query

    Invalid bracketing of name 'V:\Maintenance\I&EShop\I&E Databases\Elect. PMs\Visual PM Manager_be.accdb'.


    I am simply trying to append data from a table in another database into the current database. Not that complicated, right? But I'm getting the above error based on this statement:

    Code:
    INSERT INTO [Field SWITCHGEARList] IN 'V:\Maintenance\I&EShop\I&E Databases\Elect. PMs\Visual PM Manager_be.accdb' SELECT SWITCHGEARList.* FROM SWITCHGEARList;
    I have tried 'blah' and "blah" and [blah] and '[blah]' and "[blah]".I have even tried removing the ampersand to see if that is generating the error, without success.

    Halp!


    Grrr. I just noticed the period in the directory name. I'm stuck with their directory structure so I'll have to work around it...
    Last edited by Seamus59; 01-17-2014 at 08:58 AM. Reason: Solved

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    What are you trying to accomplish with this statement?

    is [field switchgearlist] a table?

    Are you attempting to paste a series of records from the table SWITCHGEARLIST from a table that is not in your current db into the table FIELD SWITCHGEARLIST?

    when you use INSERT INTO with SELECT you're basically pasting records from one table to another with the assumption that the table that records are coming FROM have matching fields in the table you're pasting TO.

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

Similar Threads

  1. Invalid bracketing of name
    By Access_Novice in forum Forms
    Replies: 2
    Last Post: 12-14-2013, 06:32 PM
  2. Replies: 16
    Last Post: 08-23-2013, 01:11 PM
  3. VBA Error: Invalid Bracketing of Name
    By kawi6rr in forum Programming
    Replies: 3
    Last Post: 02-21-2013, 05:26 PM
  4. Replies: 13
    Last Post: 12-12-2012, 08:17 PM
  5. Replies: 3
    Last Post: 04-12-2011, 10:22 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 - Senior Forums