Books Online should be installed with SQL Server. You should have it in your Start menu.
BCP is a command line utility, so from within SQL Server you would need a script that shells out to the command prompt (xp_cmdshell) and executes your statement. BCP has many options, which are all listed in the documentation.
DTS is probably a better option for you. It is designed for transferring data between many different formats and platforms. You can find in in Enterprise Manager (the Data Transformation Services tab). First, create your DTS package for transferring data. Then call the package from your script or as a scheduled job.
If it's not practically useful, then it's practically useless.