Post reply

updatingData in MS ACCess from SQL Server 2005

  • January 9, 2009 at 6:22 am

    #126356

    Hi,

    I would like to update few data which is in SQL Server to MS Access.

    TableA in SQL Server 2005

    TABLEA1 in MSACCess

    Now Records which got changed in TableA should be updated to TABLEA1

    So Please guide me how to go with it.

    With Regards

    Dakshina Murthy

  • January 9, 2009 at 6:26 am

    #924095

    There may be a way to do it from SQL to Access but, I would make this a "pull" by putting some type of macro in Access that will pull that data down and then schedule that macro to run on a periodic basis using different scheduling options.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply