Hi I am new to SQL Server, and nee

[sabavno]

Hi
I am new to SQL Server, and need your help
My task is to copy a SQL table into the Access table and then update an Access table once in a while based on the changes made to SQL table.
Well, first, I have to figure out the code how to copy that SQL table(actually I only to copy some of the fields)
Then I have to figure out the trigger that will update my Access table and only add changes to the table.
Finally, that update process should be automated. I need to schedule it that it will run on itself once in a while.

I am asking here for any ideas (code) to start.

Would appreciate your help

 

[onbeach]

Have you considered DTS to move the data into Access? Easy to set up....sometimes the packages are tempermental.

 

[onbeach]

Sorry I got interupted on the last post. If you want to do this, go into SQL Ent Man and right click Data Transformation Services under the database that you want to export and choose 'All Tasks' not 'New Package' as you might first think. Then choose 'export data' and voila a wizard to help you along.