Date conversion problems

[ncook]

I have rolled up a performance monitor history log into a csv report. The key field is the date and they are shown in American date format (mm/dd/yyyy) I want to import the report into Access and want to find a way of converting tha dates to English format dd/mm/yyyy. I have tried changing that date in access and at the import stage.
Please can someone help me. Thankyou

 

[doran_doran]

Advance....

The very last step when u import a text or cvs file you will see Advance button. click on the advance button. and you can then designate what format the date is.

check out the zip for print screen...

Good luck
dianna goldsberg

 

[ncook]

Thankyou, but I have tried that, I also have a different problem that the performance monitors date format has three extra digits at the end for an ID which I can not find how to remove so I can not change the format to Date/Time otherwise it does notimport any data.
e.g. 02/25/2004 16:01:11.062
Is there anything I can do in Access once the raw data has been imported because it seem that I can not remove the three extra digits as it is part of the program.

 

[a.sinatra]

Import the data, use a update query that deletes the last three charachters. Then change the field type in the table once everything is done.
________
Kd80

 

[ncook]

That is good, I have updated it but the format is still in America even though I have changed the format.