Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Wink Unanswered: Update tables from link to SQL

    Hi everyone,
    I have a SQL DTS package that reads a text file and populates a table in sql. The DTS package runs every night at midnight. This SQL table is linked to an Access 97 table. If I open Access in the morning I can update all cascading tables in access manually.

    Does anyone know a way to automatically update a Access 97 table? It would require opening access and running 1 or more queries after the DTS package in SQL runs.

    Help Please

    Dino

  2. #2
    Join Date
    Jun 2002
    Location
    Sydney Australia
    Posts
    2
    Use DTS, Access is an available source or destination.

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    Thanks... I really appreciate it

    Originally posted by Warwick
    Use DTS, Access is an available source or destination.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •