We need to create BO report using data from Excel. The excel file is similar to this,
A B C
D E F
1 2 3
The problem we have is that when we use personal data file to create and select the Excel file we need, only the numeric values go through, and in the BO report we have
#EMPTY#EMPTY#EMPTY #EMPTY#EMPTY#EMPTY
1 2 3
If we change the excel file into
A D 1
B E 2
C F 3
then it works fine in BO. It looks like BO cannot read Excel data column that are mixed with text and number. BO can duplicate the problem themselves and we are waiting for their reply.
In a message dated 98-08-21 11:13:02 EDT, you write:
>then it works fine in BO. It looks like BO cannot read Excel data column
>that are mixed with text and number. BO can duplicate the problem themselves and we are waiting for their reply.
Has anybody encounter a similar problem before ?
Try formatting the entire data range in Excel as “Text”. Then BusObj will read the area exactly as it is. I did not verify this before sending the mail, but I think I have used this tactic before.
Regards,
Dave Rathbun
Integra Solutions www.islink.com Orlando or GPF!
You may also want to use the CONCATENATE function in Excel to put double double quotes both before and after the values in cells that are to be recognized as alphanumeric. I fins this is easiest if you make a workbook with one worksheet for entring the data (cells defines as text, nice titles & colums arranged as you like) and another worksheet to be used as the personal data provider (column headings in row 1, cells linked by reference to those in the first worksheet, and surrounded by double double quotes.