您所在位置：主题：excel转换成dbf，时间格式如何转换？
1330597548
[专家分：0] 发布于 2012-04-14 11:15:00
excel转换成dbf时，时间格式都变成‘ \ \ '
_ole_excel = CreateObject("Excel.Application")
filename=GETFILE("xls")
_ole_excel.WorkBooks.Open(filename)
_ole_excel.WorkSheets(1).Activate
_ole_excel.ActiveSheet.Columns("A:A").Select
_ole_excel.Selection.NumberFormatLocal = "@"
15:00:09，都变成‘ \ \ '
_ole_excel = CreateObject("Excel.Application")
filename=GETFILE("xls")
_ole_excel.WorkBooks.Open(filename)
_ole_excel.WorkSheets(1).Activate
_ole_excel.ActiveSheet.Columns("A:A").Select
_ole_excel.Selection.NumberFormatLocal = "@"
15:00:09，都变成‘ \ \ '