Convert field like 19240525 format from .txt file to date format 05/25/1924 in access

[rohitsinha]

I have a text file with a datefield with an entry like 19240525

This is equivalent to 05/25/1924.



How do i convert this data(19240525) to 05/25/1924 when getting external data from the .txt file; Is it possible to do this?

How do we do this and transport this to access in the date format ? When i simply put date field in Access, it gives me a Type Conversion error.

[pbaldy]

You can use the DateSerial() function along with the Mid() function to pull out each piece.

[rohitsinha]

Thank you so much - Appreciate it. I will do that.

[pbaldy]

Happy to help! Welcome to the site by the way!

[rohitsinha]

Thanks Paul - In the days to come, I shall have many questions, am sure. Hope to have your and the community's support and help. Thanks again.