SQL导到EXCEL中时间格式问题
本来在SQL中为2008-04-15,可是导到excel中却变为04 15 2008,在excel中相应栏位也是设为时间格式的,请高手指点??????????急str = " insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR=YES;DATABASE=E:\11.xls','select * from [sheet1$]') select left(fworkdate,10),fworksno,fnumber,fempid,fdepartment,hqty,fdutykind from manurec"
cnn.Execute str
