While using database query with MS excel driver, and debugging the log file, there is a message [Microsoft][ODBC Excel Driver] too few parameters. Expected 2 which does not allow software to output correct data. This is the common message while querying excel file which happens because of not selecting column/cell as desired with correct format.
Note: If not it is advised to install a more recent driver set, to be found here - >>>>
exds=Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=$(IE_EXCELPATH)LDP=DBQUERY($(exds), Select [F76] from [Sheet11$] where[F14]='$(LINENUMBER)')LDT=DBQUERY($(exds), Select [F76] from [Sheet11$] where[F14]='$(LINENUMBER)')
For example, if below is the format of the excel sheet to be used Writing a query like
will give an error like
The reason being if the first row is not blank, the [F_] nomenclature can't be used to refer to columns in the Query. In that case,add a blank row on the top as shown.
If there is still some problem, then please create a Service Request and contact Bentley Product Advantage group along with the list of all relevant details to get in depth analysis and for possible solution or workarounds.
http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/18475.dbquery-usage-logging-debugging
Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!