Problems importing .xls file to BO 5.x

[kalkalai]

Hi,

just for example.... i have a .rep file i exported it to .xls file saved it on c:\

one of the columns that it contains is "dd.mm.yyyy hh:mm:ss"...

then i wanted to open this .xls file using BO again using Personal Data Files but it only shows those rows which are dd.mm.yyyy 00:00:00 , it does not show me the rows which have something other than dd.mm.yyyy 00:00:00

plz, can you help me? thanks in advance

 

[skrandel]

Are you saying it doesn't import them at all? Look at the data viewer and verify the number of rows. Don't forget, BO will import and then sort the data.

Steve Krandel
Intuit