insert into t_lclsz (lb,gysbh,djh,rcrq,rhch) values ('" & Replace(Trim$(excel_sheet.Cells(row, 2)), "珠宝类", "镶嵌类") & "','" & Trim$(excel_sheet.Cells(row, 52)) & "','" & Trim$(excel_sheet.Cells(row, 53)) & "','" & Trim$(excel_sheet.Cells(row, 54)) & "','" & Trim$(excel_sheet.Cells(row, 55)) & "')"
rcrq是smalldatetime类型,excel_sheet.Cells(row, 54)中为形如2003-12-20的字符串格式,怎么插入记录
插入rcrq怎么搞?这个字段插入有问题
rcrq是smalldatetime类型,excel_sheet.Cells(row, 54)中为形如2003-12-20的字符串格式,怎么插入记录
插入rcrq怎么搞?这个字段插入有问题