使用VBA在Excel、Word、Access中进行数据交换。从Access中取出数据,使用Excel中的参数在Word中建立需要的文件。-The use of VBA in Excel, Word, Access in the data exchange. Remove the data from Access using Excel in the parameters in Word to create documents required.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003302s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.089801s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002355s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001870s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002453s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003984s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002367s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003442s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016248s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002867s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 168090 [ RunTime:0.001576s ]