请教VB从SQL导出EXCEL中遇到的单元格式问题
CommonDialog1.Flags = cdlOFNNoReadOnlyReturn Or cdlOFNOverwritePrompt Or cdlOFNPathMustExist Or cdlOFNExtensionDifferent Or cdlOFNNoValidate
CommonDialog1.CancelError = True
CommonDialog1.DefaultExt = ".xls"
CommonDialog1.Filter = "Excel (*.xls)|*.xls|Word (*.doc)|*.doc"
CommonDialog1.FileName = "表名"
CommonDialog1.InitDir = App.Path
CommonDialog1.ShowSave
If CommonDialog1.FilterIndex = 1 Then
d_filename = CommonDialog1.FileName & ".xls"
Else
d_filename = CommonDialog1.FileName & ".doc"
End If
DataGrid1.ExportToFile d_filename, False, 0
以上为代码,可是导出的时候遇到一个问题,某字段(字符型,中间带有符号“-”)
导出到EXCEL后,格式变成类似JULY-14 格式,请高手指点如何避免这个问题,先谢过。