Loading Excel data into SQL server - Extra NULL Rows added

Question

I'm trying to import data from an Excel sheet into a sqlserver database. I used the sample code that is in this link. However, when an import is made extra 22 rows with NULL values are being copied. I'm not sure how to remove the NULL values.

Database screen shot

Still not sure why the NULL values are being copied and exactly 22 rows each time. — Vinshi
– Vinshi, Commented Apr 23, 2014 at 15:12

Zak · Accepted Answer · 2014-04-22 18:11:39Z

3

In the select statement, try adding a WHERE clause to exclude the nulls. EX.

select student,rollno,course from [sheet1$]

Becomes:

select student,rollno,course from [sheet1$] where student IS NOT NULL

answered Apr 22, 2014 at 18:11

Zak

4613 silver badges8 bronze badges

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

Comments

Eric J. · Accepted Answer · 2014-04-22 18:04:23Z

0

In the code

    while (dr.read())
    {
        bulkcopy.writetoserver(dr);
    }

you could check dr to see whether all of the columns are null, and if so skip the call to bulkcopy.writetoserver().

answered Apr 22, 2014 at 18:04

Eric J.

151k65 gold badges353 silver badges563 bronze badges

Collectives™ on Stack Overflow

Loading Excel data into SQL server - Extra NULL Rows added

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related