i have load two data files into a mysql table.now i want the compare the data from these two files (i.e want to compare a particular column of the table and want to get the difference between the values from these two files).
i dont know how to do this.can anyone help me out with this?
jagpreet
0
Newbie Poster
Recommended Answers
Jump to PostYour description is kind of vague. So, I'm going to make a couple of assumptions. Firstly, the two data files are similar in structure. I assume that the first data file has a key field that you can search for in the second data file. Secondly, I assume that having …
Jump to Postrs.open "SELECT C2 FROM Table_Name"
C2R1 = rs("C2")
rs.MoveNext
C2R2 = rs("C2")
compare C2R1 and C2R2
Hope this helps.
All 8 Replies
hopalongcassidy
35
Junior Poster
jagpreet
0
Newbie Poster
yello
3
Light Poster
hopalongcassidy
35
Junior Poster
jagpreet
0
Newbie Poster
hopalongcassidy
35
Junior Poster
yello
3
Light Poster
jagpreet
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.