Hi,

I am trying to export all the data from xls file to Data table using DataBase package. Query used in the export to data table command is Select * from [Sheet1$]. When looked into number of columns in the Data table, it is not matching with what is in xls file. Tried to use select query with all columns, Select column1,column2,...column20 from Sheet1$], this is throwing error “No value given for one or more required parameters”, but when any one column is removed it works as expected.