This is not a good question for this forum as it is too large a subject and not specific enough.
I'm afraid you are going to have to persist with the tutorials and documentation you can find on line. The following information might help you though:
The tool you will need to use is called SQL Server Integration Services, or SSIS for short. Prior to SQL Server 2005 it was known as DTS. You are going to want to set up some "Tasks" in SSIS to do what you want and you can use a SQL "Agent" to automate those tasks.
The only "official" tutorial I've been able to locate quickly is this one -
SSIS Tutorial: Creating a Simple ETL Package[
^], however it only goes back as far as SQL Server 2008. You may still benefit from following it but there are also some useful articles here on CodeProject that might be of more help:
SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages[
^]
How to Create your First SQL Server Integration Services (SSIS) Package - Part 1[
^]
Once you have been through the tutorials, if you are still struggling then do come back with more specific questions if you need help.