Error while reading Excel file using OleDbDataAdapter

Question

We are importing some data from an Excel file into SQL. For this we are reading Excel file using OleDbDataAdapter. We want to read filtered data of rows where there is some value in specific columns. We have written a query like following:

SELECT * FROM [Sheet1$]  WHERE  [F6] IS NOT NULL OR [F7] IS NOT NULL OR [F8] IS NOT NULL OR [F9] IS NOT NULL OR [F10] IS NOT NULL OR [F11] IS NOT NULL OR [F12] IS NOT NULL OR [F13] IS NOT NULL

This query works on some files, on some other files it gives an error saying - No value given for one or more required parameters.

I have tried several combinations but it is not working. Any help would be appreciated.

Thanks, Rahul Jain

Are you sure that the files where this query doesn't work have at least 13 columns? — Steve
– Steve, Commented Jun 17, 2018 at 14:09

Rahul Jain · Accepted Answer · 2018-06-17 14:20:52Z

1

I am able to solve it by including HDR=No in the connection string. Files which were not working had some values in first row.

Thanks everyone, Rahul

answered Jun 17, 2018 at 14:20

Rahul Jain

1951 gold badge5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while reading Excel file using OleDbDataAdapter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related