I need to join some additional columns from SQL Server into the worksheet ...

Accounting has provided me with an Excel worksheet with several columns of
data, one of which is AccountID. There is a table in SQL Sever which also
has AccountID. I need to join (using AccountID) some additional columns from
SQL Server into the worksheet as new columns, save, and then send the
spreadsheet back to Accounting. What is the simplest method to accomplish
this? I would prefer a non programming approach with the fewest steps so
Accounting can do this themselves next time.DTS would be the easiest, if you can get the data into a staging table. Once
the resultset is generated you can get it back to the spreadsheet easily.
Alternatively, another "non programming approach" would be to use the rowset
provider OPENDATASOURCE. Check out the example in SQL Server Books Online
which shows how to use this with OLE DB provider for Jet.
Anith

I need Help In SQl Server

Hello

I need Help In Sql Sever

I need Some one tell Mw What Is The Numeric(18,0) mean

It means you have NUMERIC data type with a precision of 18 and scale of 0 which is the default, scale is the values to the right of the decimal point. Numeric and Decimal are almost the same, if you are writing a .NET application try to use Decimal because there is no Numeric in .NET FCL(framework class library). Try the link below for the SQL Server docs for Numeric and Decimal. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms187746.aspx