OleDB Command Question

Answered

Comments

4 comments

  • Hello,

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

    0
    Comment actions Permalink
  • Avatar
    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 ?

    0
    Comment actions Permalink
  • Avatar
    Shang

    Hello,

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

    Thanks very much.

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink

Please sign in to leave a comment.