查询表达式中的语法错误（缺少运算符）。 [英] Syntax error (missing operator) in query expression.

问题描述

请帮忙，我一直在努力解决它





使用vb.net中的sql查询从excel表中提取数据。



MyCommand = New System.Data.OleDb.OleDbDataAdapter（select [Imp]，sum（Assigned Group ='abc'）abc from [MAN_Dump $]分组by [Imp]），MyConnection）

Please help,I've been trying to solve it


Extracting Data from excel sheet using sql query in vb.net.

MyCommand = New System.Data.OleDb.OleDbDataAdapter("select [Imp],sum(Assigned Group='abc')abc from [MAN_Dump$] grouped by [Imp])", MyConnection)

推荐答案

按[Imp]分组，MyConnection）

grouped by [Imp])", MyConnection)

如果你试过运行查询

If you tried to run the query

select [Imp],sum(Assigned Group='abc')abc from [MAN_Dump

中选择[Imp]，sum（Assigned Group ='abc'）abc查询分析器/ SSMS /访问查询中的Imp]）

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

这篇关于查询表达式中的语法错误（缺少运算符）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！