用C#讲SQL SERVER数据生成ACCESS,EXCEL的问题,高手请进!
yfx82 2005-06-20 10:59:36 小弟需要实现将SQL SERVER数据到入ACCESS,EXCEL的功能,功能基本上完成,但遇到一个棘手的问题。如果要导出的数据有dateTime或者money ,生成的SQL语句执行抱错,说是字段定义出错,我把dateTime或者money类型强行转成string类型还是一样的错。
程序的愿意是讲SQL SERVER的表提取为DATATABLE然后用OLEDB连接ACCESS,EXCEL,生成建表语句和插入数据语句。
这是原始的包含DateTime类型的SQL语句:
create table Register_Patient ( PatientID NUMBER, UserName STRING, NickName STRING, TrueName STRING, PassWord STRING, SocialInsuranceCode STRING, Sex NUMBER, Email STRING, Birthday DATETIME, CertificateType STRING, CertificateCode STRING, Mobile STRING, Tel STRING, Address STRING, Zip STRING, Province NUMBER, City NUMBER, Flag NUMBER, addTime DATETIME, State NUMBER, RegIp STRING, LastLoginTime DATETIME, LoginCount NUMBER )
这是我把DateTime类型强行转换成STRING的语句:
create table Register_Patient ( PatientID NUMBER, UserName STRING, NickName STRING, TrueName STRING, PassWord STRING, SocialInsuranceCode STRING, Sex NUMBER, Email STRING, Birthday STRING, CertificateType STRING, CertificateCode STRING, Mobile STRING, Tel STRING, Address STRING, Zip STRING, Province NUMBER, City NUMBER, Flag NUMBER, addTime STRING, State NUMBER, RegIp STRING, LastLoginTime STRING, LoginCount NUMBER )
这是不包含DateTime或者Money类型的可以成功执行的SQL语句:
create table Register_Bureau ( BureauID NUMBER, BureauName STRING, BureauLevel NUMBER, Introduce STRING, Province NUMBER, City NUMBER, Area NUMBER, Address STRING, LinkMan STRING, Tel STRING, State NUMBER )"
请问一下是什么原因造成这种错误,怎样改进了,请赐教,多谢了