Networks·41,393 discussions

Comparing data in mssql2000 with excel using vb6

Locked

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….

Topic

Clarifications

In reply to Comparing data in mssql2000 with excel using vb6

Clarifications

Why don’t you

In reply to Comparing data in mssql2000 with excel using vb6

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.

[Author]

Replies