If you're using the Text wizard to bring the file in, on the third
pane, select the date column and choose YMD from the date dropdown.
I'm not sure what trouble you're having with time - what are you
seeing?

In article ,
"Nazrul" wrote:

I have an ascii file to read date, time, data1 and data2
as shown below from EXCEL.
1999-10-25 00:00:00 0 0
1999-10-25 00:03:00 3.657 0
1999-10-25 00:06:09 3.657 26831.4

I can read data1 and data2 correctly, but not date and
time. Is there somebody who can help me out?