Active Query Builder support area

OleDB Command Question

Avatar
Shang
  • updated
  • Completed

Hi:

Version:Professional ASP.NET Edition 2.11.1 (released at 15 Apr 2016)

I use Excel file to query but table name no '[' & ']' in query string , I using command will error.

How to do, let table have '[ ]' Coated? Thanks.


Correct query string:

select * from [ 工作表1$ ]

Replies 4
Avatar
0
Andrey Zavyalov, PM

Yes. We developed special syntax providers for different SQL engines that support different SQL syntax and metadata extraction rules. It's a good idea to use them rather than uncertain generic syntax. MS Jet is a common SQL engine that is used to work with MS Access, Excel and Text/CSV files. MSAccessSyntaxProvider suits for all of these data sources.

Avatar
0
Shang

Hello,

I tried to use MSAccessSyntaxProvider for OLE DB connection to Excel is ok.

Thanks very much.

Avatar
0
Shang

Hi:

I use c# code information:

GenericSyntaxProvider syntaxProviderGeneric = new GenericSyntaxProvider();

queryBuilder.SyntaxProvider = syntaxProviderGeneric;
queryBuilder.MetadataProvider = new OLEDBMetadataProvider { Connection = connection };

So I must to use MSAccessSyntaxProvider for OLE DB & MS Jet ?

Avatar
0
Andrey Zavyalov, PM

Hello,

What syntax provider do your use? I recommend to use MSAccessSyntaxProvider for OLE DB & MS Jet connection to Excel.