Post reply

copying data to access database from sql 2000

  • November 29, 2006 at 8:18 am

    #114763

    hi!

    i want to copy some data from the desired view to an access database. is it posible through any programe writen in tsql ? if yes then plz provide me the solution and if there is anyother way to accomplish this task plz guide me.

    atif saeed khan

     

    Kindest Regards,

    Atif Saeed Khan

  • November 29, 2006 at 8:34 am

    #674680

    DTS is the easiest way to do this. Open a new package, add a connection to SQL Server and one to your access db. specify your view and destination table, then you can map the columns between them.

    You could also link to a SQL Server view from Access and get the data that way.

    Either of these topics are discussed in the help files for the products.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply