Download Data from one SQL server to a local server

Hi I am trying to download data from one sql server to a local table. What are my options?

Thanks.What do you mean by local table? A table on your local Sql Server? If so the easiest thing to do is right click on the source table in Enterprise Manager and select "All Tasks->Export Data" and follow the wizard to copy the table to your local server.sql