Copy data through SSIS package from one machine to another
Depending on how much data you are loading into SQL Server from Excel, you can choose different routes :


When designing SSIS package, you can use configuration file. The advantage is that your packages will be customizable, like when you are developing it can point to your local server and when you want to promote it to prod, you just have to change connection string to point to PROD server. Good example can be found here.
Use Bulk Insert to load data.
As @listik mentioned, you can use Import/Export wizard as well.
You can use linked server too as described here.


SSIS will be more flexible and customizable.