Updating offline

Results 1 to 2 of 2

Thread: Updating offline

  1. #1
    Join Date
    Dec 1969

    Default Updating offline

    I have a table in an offline Access dbase that I need to update and import into my online SQL Server7 dbase every week or so.<BR><BR>At the moment I delete the old table from SQL Server and import a new copy.<BR><BR>Is there a better way. I worry about the site being down for a few minutes (and longer if the import goes wrong). But I think there can be problems in SQL with importing a table with the same name (I have ended up with duplicate records before rather than overwriting...)<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating offline

    You need to look into DTS and you will see you can import the data quickly each time. This can be done sd hoc or scheduled

Posting Permissions

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