1 Reply Latest reply on Oct 16, 2007 12:28 PM by Xuan Mai

    SOT: Automatically move Access data to SQL Server 2005

      Hi all,

      I hope this is not too off topic. Does any one know of a methodology to automatically move Access data to SQL Server 2005?

      Here is the scenario. The Client is syncing their AS400 to Access. They want to upload the Access db to the server and then run a routine to basically purge the tables and repopulate them with the Access data.

      My first suggestion was to just do this manually, Second to write a CF routine, but then they asked about something at the SQL level.

      Any thoughts are welcome.

      Thank you,