Unfortunately, I don't have SQL Server at work, and I can't really remember the steps...
...but you should be able to use one of the many wizards in SQL Server (Import/Export rings a bell) and save it as a DTS package. Then you can either reuse this package over and over, or have a poke around through the DTS UI to see how it works and how to customise it.