Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101

    If you have both tables in your Access front-end, have you tried to create an append query using the query wizard and see if it works?
    https://community.powerbi.com/t5/Des...or/td-p/310074
    Can you post a couple of pics with the two tables in design view from your Access front-end?
    Also, can we see your VBA sub where you are trying to run this from?

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  2. #17
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Oops, I forgot this in my first post......

    When I was editing your SQL statement, it appeared that your "apostrophes" are not ASCII apostrophes.
    I don't know what the char code is, but it is not a standard apostrophe.

    I'll back out for now - I am at a loss ..........

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-07-2018, 07:08 AM
  2. How to write data into linked MySQL table
    By mr.viskers in forum Programming
    Replies: 5
    Last Post: 03-13-2015, 02:51 AM
  3. Inserting Data to Access Table (Local) from MySQL table (Net)
    By gambit1430 in forum Import/Export Data
    Replies: 2
    Last Post: 09-26-2014, 01:34 AM
  4. Replies: 0
    Last Post: 05-21-2012, 11:54 PM
  5. Creating a table with local and external data
    By Accessnoooob in forum Access
    Replies: 8
    Last Post: 06-25-2011, 07:36 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