Networks

Ask something
Question Locked

Comparing data in mssql2000 with excel using vb6

0 helpful
2 replies

by manojgadiyar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Now, I have retrieved or imported data from excel spreadsheet to vb6 application. Now I want to compare this part of data with the one already existing in mssql2000 server(table name being same). If some data which is there in excel spread sheet not to be found in mssql2000 server then those data has to be stored in a seperate table in mssql server.
Can anyone please help me with the code....

2 replies

by tony hopkinson

import the data into MS SQL and then, compare it with a query or three.

You can do it in VB6 via code.
You could even have done it in excel, by linking to the sql data.

This discussion is closed to new replies.