Re- Formatting of date in column

[lawdie]

Hi all,

I'm importing a CSV file of raw data daily into access

One of the columns (DATE) is coming in as below format

20030403

I need Access to see it correctly. 03/04/2003

Theres a workaround in Excel left mid right. But does anyone have a direct answer to the problem in Access.

Thanks, Lawdie

 

[Corticus]

Hi lawdie,

Are you importing the data into an existing table or creating a new one every day?

 

[gator]

I have this problem all the time-

Do the following

Step 1: Create a new field in the database with Data type= date (lets call it service_date)

Step 2: Create an update query where you update service_date to = format([old_date],"0000/00/00")

hope this helps

-gator