Unable to execute query onfor excel as database

Help Studio
, ,
1

I am trying to connect excel as database but after connection is established, run query command is failing with ‘too few paramaters’ because my header line starts from row no 3 and first rows are merged and centered with image

2

@chandresh_agarwal,

Can you the sample excel file and the query you are trying to run?

3

@chandresh_agarwal

In you query you can specify the start cell you want it to read from as well

Cheers

4

Can you pls help me with query

5

Daily_Status_Tracker.xlsx (10.7 KB)
Query - “Update [” +“Daily Status” + “$] SET [Comments] = '” + “Success” + "’ WHERE [Sr No] = " + “1”

6

Try this add the range this way

Query: UPDATE [Daily Status$A3: ] SET [Comments] = ‘Success’ WHERE [Sr No] = 1

Hope this helps!

7

Run query: ERROR [42S02] [Microsoft][ODBC Excel Driver] The Microsoft Access database engine could not find the object ‘Daily Status$A2:’. Make sure the object exists and that you spell its name and the path name correctly. If ‘Daily Status$A2:’ is not a local object, check your network connection or contact the server administrator.