Hi,
I have a excel spreadsheet with a date in a format of ddmmyy (280912)
i import the spreadsheet into a table but want the field to be imported in format "dd/mm/yy"
How do i do this?
from the append query or after the table has been updated
if from the append query, how do i accomplish this?
I have a excel spreadsheet with a date in a format of ddmmyy (280912)
i import the spreadsheet into a table but want the field to be imported in format "dd/mm/yy"
How do i do this?
from the append query or after the table has been updated
if from the append query, how do i accomplish this?