怎样将EXCEL数据导入SQL Server2000

select into t# FROM openrowset( 'MicrosoftJetOLEDB40',
'EXCEL 50;HDR=YES;IMEX=1; DATABASE=d:\kq\salaryxls',Sheet1$)
上面是在sql server查询分析器直接导入数据，意思是将d:\kq\salaryxls的sheet1导入到sql server的表t#(该语句会新建表，如果sql server已经存在该表会报错)

//第一题：#includevoidfun(chara[],charb[]){intl;/获取较短数组的长度/if(strlen(a)usingnamespacestd;classCircle{public:voidinput(double);//输入voidprint();//输出doublegetArea();//计算半径private:doubler;//半径};voidCircle::input(doublea){r=a;}doubleCircle::getArea(){returnrr314159;}voidCircle::print(){cout>a;cinput(a);cprint();return0;}

---