Using DTS for replicating Access Data

• fryere

  Ten Centuries

  Points: 1054

  More actions

  August 17, 2006 at 12:00 pm

  #169399

  I may in the near future have the need to import some Access databases into a master database.  I was curious if DTS/SQL Server replication might work for this.

  Once a month I would receive 10-30 databases that remote users update and update all the new data into a Master database. 

  Any Thoughts?

  Thanks.

   

  fryere

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 17, 2006 at 1:22 pm

  #655530

  DTS will work, not sure if you can replicate from Access to SQL Server.  I'd create a DTS package and schedule it as a monthly job.

  Greg

  Greg