Appending from Access to SQL

Results 1 to 3 of 3

Thread: Appending from Access to SQL

  1. #1
    Join Date
    Dec 1969

    Default Appending from Access to SQL

    I need every week to append data from an Access database (stored offline) to an SQL Server dbase (stored online).<BR><BR>How would you do it? Eg do it online or offline? And can you point me to some sample code for Appending in ASP?

  2. #2
    Join Date
    Dec 1969

    Default appending?

    if you just need to move data from access to sqlserver, write yourself a little app that grabs the datafrom access and puts it into a recordset, then uses the recordset to do an update query on the sqlserver<BR><BR>that&#039;s one approach

  3. #3
    Join Date
    Dec 1969

    Default RE: Appending from Access to SQL

    You can create a DTS package in SQL Server to get the data from the access db and insert it into th SQL Server and set it up to run once a week automatically so that you won&#039;t have to do anything.<BR><BR>Just select Import Data from inside SQL Server and select the Access db as the datasource and check the box to have it run automatically, which also allows you to set the time and the interval when it will run

Posting Permissions

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