Skip to main content
Question

Export to data table from excel file - Unable to export more than 19 columns from excel to Datatable

  • December 17, 2024
  • 1 reply
  • 77 views

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. 

1 reply

Forum|alt.badge.img
  • Cadet | Tier 2
  • December 18, 2024

Hello ​@bhakthi,

 

Quick check, does your column not have headers in it?

 

The Select Query with the columns you mentioned shouldn’t have started from column0?

 

Hosni