Hi all, I’m trying to dynamically assign values while using excel as DB Error: Run query: ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 2. Command I’m Giving "SELECT SUM(PEJAMT) AS SUMTOTAL FROM [Query$A6:Z] WHERE [PEACCM] = @PEACCM AND [PEACCD] = @PEACCD " [image] …

Unable to Insert Parameter while using Excel as DB

Krishna_Raj (Krishna Raj) March 1, 2024, 6:30am 2

check the thread

Topic		Replies	Views
Excel as DB, getting exception for run query - object reference not set to an instance Activities excel , database , activities , studio , question	5	972	June 13, 2022
Unable to execute update query in run query activity with parameters Studio studio , question , activities_panel	4	407	January 17, 2024
ODBC Excel as a database using named parameters Studio excel , studio , question , activities_panel , excel-scope	4	748	October 2, 2023
Using excel as db Studio excel , studio , question , uipath-database-activities	7	294	March 3, 2024
Unable to execute query onfor excel as database Studio studio , question , activities_panel	6	102	November 5, 2024