How to insert excel sheet into sql server using vb 6?

[Niki_S]

I have a excel sheet as below,

And now I want to get these data into my sql server as below,

When inserting data into my sql server I don't want to insert duplicates and null records.
How can I do this?

Thank you.

 

[strongm]

Onc e again, your examples don't make sense - the output you show does not match your requirements. For example, what has happened to "2 mark in" or "96 mark dart"?

 

[Niki_S]

I don't want to take them because those records haven't all three columns.

 

[Andrzejek]

In VB6, open your Excel file, point to your worksheet if needed.
Start in row 4 (Row counter)[pre]
If Columns E, F and H have values Then
If those values do NOT exist in your table Then
Insert this record to your table
End If
End If
Add 1 to your Row counter
If next row is Empty
You are done.
End If
[/pre]
Reset your Row counter to 4 (again) and
Repeat the same for Columns Q, R, and U

Actually, you do not even need VB6, you can use (pretty much) exactly the same code to do all of that from Excel’s VBA. To be honest, the code would be even shorter since you do not need to connect/point to Excel, you would already be in Excel

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[strongm]

Wondered how long before you spotted that, Andy ...

 

[Andrzejek]

You know - first you do it the hard way, and then you improve it.
Better than the other way around...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[Andrzejek]

Niki_S,
Any progress...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson