Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Excel query No value given for one or more required parameters

Hi Folks,


I am trying to get data from excel using query and my connection string is  as follows:


Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%FullPath_ExcelFile%;Extended Properties="Excel 12.0 XML;HDR=NO;IMEX=1; ";



1.) Suppose if  i use select query like select * from [TableName$]  i am getting result 


2.) If i use select query for particular column  like SELECT [ColumnName] from [TableName$]  i am getting exception as  

Runtime Error: Error in SQL Statement: No value given for one or more required parameters. Can anyone help on this 




1 Comment

ADMIN

Dear Indra, 


Thank you for getting in contact with us. 


Please note that the specific forum category is not related to your request.

Hence, we strongly suggest that you consider creating a new support ticket and our team will assist you accordingly. 

Have in mind that only users with an active SSMP (Software Support and Maintenance Plan) subscription are eligible for our support services. 


Thank you and best regards!