Excel query No value given for one or more required parameters
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
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!