ѧ¼ϵͳѰ  7
ï tim.afan@qq.com
ִϵ~~~

ڹѧϵͳ¼Сߡϵͳʹͷۣ¼롢ӡҪʹ~~~ʹñ¼ϵͳȥʹ࣬
¼ϵͳɫ1)Զͬʱ¼(SQLģʽ)2)Ϊͷ۵¼룬бѡ3)ְӡǳ㡣

1.  Ҫ޸config.iniļ"server"MS SQL ServerĵַdatabaseǴ洢ѧݵݿƣuserpassword͡㲻SQL Serverĵ8㡣
2.  xueji.mdbInit1Init2뵽SQLУ䡣Ȼ޸ķInit2ѵһֶidıʶΪǡ
3. ÿǷֿ洢ģ"һ1"/"3"ȵȣ¼ɺҪԼϲڱҲṩ˺ϲܣڡܡ
4. ֶ"_"Ӧԭģ"/"뵼ʱҪע⡣Ϊ˶Ըٵ룬ĩβĸֶΣ"???2"ȵȡĸֶαʵʵڵأΪ˷ӡУԵġҳ440606450332Щǻֶκexcelģһ¡
5. кöûǺŵֶûдΪNOTеĵۡ
6. ༭ˣһεܡʦťͻʾڵϽǡΪƸѧʹ&æ¼ģѧʱΪ༭ʧλݡ
7. ṩѾõתĹܣΪɿṩ˼·(δ֤)
--	UPDATE һ1 SET һ1. = .AreaId 
--	FROM һ1,  
--	WHERE һ1. = .Area
8. Ҫ߲ŪSQL ServerӲ-accessУֱӵǸbatݻ洢xueji.mdbACCESSݿ档ģʽ¼롢ӡȴ󲿷ֹܶû⡣һСָ߼֧ܿܲ֡ʱһòҪֿ¼룬ϲmdbʱͷۡ
9. ȫɺȺϲȻ󵼳ԭʼexcelһidţɾ֮ѳ˵һеиƵģ壬Ȼѧϵͳע⣬ݣҪԼ²ܹ뵽ѧϵͳС"1-"ȫ滻""ȵȡ
10. þܰĴԼԾϵͳŪͺ鷳Ѿṩ˼ȽҪĲܣһҪʹá⣬ṩһЩ˼·SQLϤʦ
--鼮̫̫̣select * from ϲ where len()<=3
                      select * from ϲ where not( like '%ʡ%')
--룺 select * from ϲ where len()<>6
--֤غţ select * from ϲ where ֤ in (select ֤ from (select ֤,count(֤) as CNT from ϲ group by ֤ having count(֤)>1) TA )


£
2
  1봦ڵءصʹб롣

3
  1ԭ6λ9λĩβ㡣
  2дˣûϸĶˡѾ¼˵̨ҪԼSQL޸ˡ
  3˶ݸе⡣
  4ѿ༭ǸѡˣΪѧȥȻûбݾͶˡ

4
  1룬Ӹ۰̨δ걨
  2Ӵӡܣ㡰ܡť롣԰һ˵ݵһworkbooksheetģУҪԼǸtemplate.xlsģ壬ʹ֮һ˸պôӡһҳ

5
  1¼ʱͬѧظ롣
  2ɽ¼롣
  3˺ܶڴҪĹܡϲа༶һݱɰչԭʼĽṹÿ¼Ŀÿ¼ļ¼ÿİţ鿴Ƿֶŵ(~~~)Ժϵͳʱ̵̫ļᡣ֤Уļ¼ԼͷǾ֤ļ¼
4ӣת롣汣"1-"/"0-"ݡΪ֪ٷϵͳʲôֵԺܡݾȷݿûµġ

6
  1Ľ˼ӡйصĹܡҷֵŵŵĴӡ̫ʹ̫ˣ͸Ľģtemplate.xlsȵӡģ()Ȼexcelӡܶˡ
  
  
  