Thansk everyone. I used Earls solution as it was the shortest. Really
appreciate everyone's quick help.

"Dan Harlan" wrote:

Need to convert a bunch of text files that include dates in the "Fri Aug 22
13:49:20 EDT 2003" format. Have been unable to break them into separate
columns during import as the other columns are all tab delimited. Wish to
convert this into a standard date/time format. How best to achieve this as I
have numerous files to do this with. TIA, ~Dan