DataType

I have a column with data type date Custom #jjjjmmdd# eg 20070401
He should write this in DataType : Text.
If you convert this to Text he gives you the serial number what is normal.
When I import this sheet in access, I get the serial number and not anymore the date 20070401. This is not what I need. For my output in access I need the text 20070401 (DataType Text).

20070401 39173 (corresponding serial number)