If you tried to run the query
select [Imp],sum(Assigned Group='abc')abc from [MAN_Dump$] grouped by [Imp])
in Query Analyser/SSMS/Access Query you are going to get all sorts of syntax errors.
You might want something like
select [Imp],sum(Assigned) abc from [MAN_Dump$] group by [Imp]
If you are really using SQL then I suggest using the
SqlDataAdapter Class (System.Data.SqlClient)[
^] rather than the
OleDbDataAdapter Class (System.Data.OleDb)[
^] ... either way you will need to get the syntax of the query right