Results 1 to 3 of 3
  1. #1
    Babiecino is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2015
    Posts
    1

    Any way to append data from SQL view?


    Hi, I need to load import data from an SQL view so that my team can enter notes regarding each record in Access. My original SQL table has data loaded to it every night. How do I append the new data daily into Access? The link option has problems since its connected to a view right? The import option simply creates a new table and doesn't actually append to my existing access table.

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    If I understand you correctly, you are correct that you can not enter data through an Access link to a SQL View. You have to enter the data from the base tables that create the view. Then the SQL view will display the information once the base tables have the data.

  3. #3
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you are just asking how to write new records data from a linked SQL table to a static access table, you can use an Append Query to do that.
    If you Google "Append Query in Access", you will find many tutorials/videos that show you how to create one.

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

Similar Threads

  1. Append data from one query to another
    By basabnanda in forum Queries
    Replies: 7
    Last Post: 07-29-2014, 10:24 AM
  2. Replies: 2
    Last Post: 01-28-2014, 10:13 PM
  3. append data
    By slimjen in forum Programming
    Replies: 5
    Last Post: 04-26-2013, 11:58 AM
  4. Replies: 1
    Last Post: 07-16-2012, 02:10 PM
  5. Data append to table
    By ali zaib in forum Access
    Replies: 4
    Last Post: 01-13-2012, 11: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