As shown in the appended drawings, the query is as follows:

The select customerid, Reno, p1, p2, p3, p4, p5 from DateCodeRecorder inner join
PlanarNum_Dc on DateCodeRecorder. Reno=PlanarNum_Dc. Dc_id
And customerid between 40109290013789 And 40109290013799

I want to do a small program, the X1 and X2 instead of 40109290013789 and 40109290013799, their range of input, then check the results with the database query, they can export to EXCEL, program design as below, thank you!

CodePudding user response:

Behind you,

CodePudding user response:

Search "VB6 ADO"

CodePudding user response:

refer to the second floor zhao4zhong1 response:

search "VB6 ADO"

thank you, has been done