XMLSQLNinja (8/16/2012)
... Perhaps some more detail would help.
For example...
-How do want the data from the server to be shown on the PC? Flat file, XML, Excel, CSV, what?
-Do you have an instance of SQL server on your PC with a target database available to receive the table? In that case, a simple
SELECT <fieldlist>
INTO <your.local.PC.table>
FROM <your.SQL.source.table>
would suffice.
-Do you want to have the data in Excel? Do an Export from SSMS.
The answer to your question is "Yes", but you didn't give us enough detail to allow us to help you get to your preferred end-state.