Unable to Insert Parameter while using Excel as DB

[ch460960]

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 "

Thanks

[Krishna_Raj]

@ch460960

Excel as DB, getting exception for run query - object reference not set to an instance

I have now directly used the expression in query which I was assigning to parameters and it worked. But I could not figure out what is the issue with passing parameters.

check the thread

[ch460960]

It’s clear in that thread, he is not able to pass parameter either rather he passing value directly.

[lrtetala (Lakshman Reddy)]

Hi @ch460960

Try this

"SELECT SUM(PEJAMT) AS SUMTOTAL FROM [Query$A6:Z] WHERE [PEACCM] = '" & yourPEACCMValue & "' AND [PEACCD] = '" & yourPEACCDValue & "'"

[ch460960]

Hi @lrtetala ,

Thanks it works… mention in that Thread what @Krishna_Raj posted earlier. Is there any way I can pass parameter? What is the use of parameter property then?

Thanks