File Date appending

[Guest]

Wondering if someone can help me. I have these files that uploades onto this
database i created. Now, when it upload it takes the files name of the file
and insert it on the table.
The file comes like "CDI ERROR FILE xx-xx-xxxx", where the x is the
month-date-year. I need to have take that file name and when it append only
have the month-date-year. Please assist. Thanks

 

[Guest]

Wait, I am not following
the table that i uploaded the file to, also has the file name
Now i created an append query to clean up the data. I want the append query
to have it take teh file name and make it into Date.
I tried to insert that function on the append query, but it didn't work.
Maybe Im doing somethign wrong. Please help

 

[Ron Hinds]

UPDATE table_name SET column_name = Right([column_name], 10)

Assuming the date format is always "xx-xx-xxxx"