N in the same folder. XLSX file (file name random uncertainty, such as 5) and a CS - T.a CCDB file, how to realize the batch will each EXCEL file Sheet1 specified cell (such as top 10 cell b6, c7, d8, e9, f10, c2, h12, a1, g5, d9) summary to CS - T.a CCDB table Mark_Info, corresponding field T0, T1,... T9,

Don't know that I can see of understand, which the teacher can guide the, thank you!

CodePudding user response:

Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

Will need to collect statistical data spread in clutter cell, this itself is a kind of design error,

Let the associated data in advance in orderly cell arrangement, through external database engine can efficiently query statistics, also can easily to get the record set in any other format database table,

CodePudding user response:

Didn't go off work behind the hair not beauty