OBIEE导出了csv，当导入到Access时出现错误 [英] OBIEE exported csv and when importing to Access I get an error

问题描述

我有关于OBIEE的报告，在 date 字段中将其设置为 MM-DD-YYYY 的自定义格式，我也尝试了 [FMT:dateShort] .导出到.csv后，我将文件与MS Access 2007和日期字段链接在一起，我收到错误消息 #NUM！，为什么?

I have a report on OBIEE, the date field I made it Custom format to MM-DD-YYYY I have also try [FMT:dateShort]. Once I exported to .csv I am Linking the file with MS Access 2007 and the date field I get an error #NUM! why is that ?

推荐答案

其中一个可能是问题/解决方案:

#Num！在Access中告诉您该单元格包含混合数据；一些数字，一些文本，例如:34G(或您的-")将抛出#Num！

The #Num! in Access is telling you the cell contains a mix of data; some digitit, some text, for example: 34G (or your '-') would throw a #Num!

您需要返回Excel并将包含数字和文本的任何单元格的格式更改为混合数据"，然后保存该工作表，然后再导入到Access中.

You need to go back to the Excel and change the format of any cell containing both numbers and text to "mixed data" then save that sheet before importing to Access.

您可以使用宏执行此操作:

You can do this with a Macro:

Sub Addspace() 
  Dim cell As Object 
  For Each cell In Selection 
    cell.Value = " " & cell.Value 
    cell.Value = Right(cell.Value, Len(cell.Value) - 1) 
  Next 
End Sub 

只需突出显示需要格式化的单元格，运行上面的宏，然后重新保存电子表格即可.

Simply highlight cells needing the formatting, run the above macro, then re-save spreadsheet.

或:

#Num！错误值表示基于字段的DataType或FieldSize属性设置，字段中的值太大(正或负)而无法存储在字段中. ( https://support.microsoft.com/en-us/kb/209132)

The #Num! error value means that the value in the field is too large (either positively or negatively) to be stored in the field, based on the field's DataType or FieldSize property setting. (https://support.microsoft.com/en-us/kb/209132)

根据您的日期格式，我会先尝试进行第一个修复.日期=/=数字

Based on your format of the dates, I would try the first fix before anything else. Date =/= Number

这篇关于OBIEE导出了csv，当导入到Access时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！