Results 1 to 2 of 2
  1. #1
    neockder is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    14

    Updating new records in Local Tables via ODBC connection to SAP B1 SQL server tables

    Hi there,

    I searched for quite a while for my exact problem, with no luck. Platform - MS Access 2010.



    Here is what I'm trying to do:

    We use SAP B1 for all data entry. I have created an MS Access backend with ODBC linked tables. I've then converted those linked connections to local tables, for usability. The Access front end in turn houses the forms, queries, linked tables (to the local tables in backend), etc.

    I want to create an updade/insert query of some sort so I can refresh the local tables in the backend to pull in any new data from SAP (SQL server 2008 i believe). How would I go about pulling in only new records from the ODBC connection to the local tables housed in the Access backend?

    Thanks much for your help!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,863
    Perhaps this thread will get you on a road somewhere.....
    https://www.accessforums.net/access/...ion-34715.html

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

Similar Threads

  1. Replies: 1
    Last Post: 05-17-2012, 05:51 PM
  2. Replies: 0
    Last Post: 03-08-2012, 03:12 AM
  3. Updating tables with new data from ODBC?
    By Compass in forum Access
    Replies: 0
    Last Post: 03-07-2012, 06:22 AM
  4. Replies: 1
    Last Post: 07-17-2010, 08:29 PM
  5. Linked tables and ODBC connection strings
    By cwcadm in forum Import/Export Data
    Replies: 7
    Last Post: 05-26-2009, 07:30 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