G
Guest
I have a text file that I am importing into Access. All fields populate
correctly except for the date fields. They import as text "06082007" and
need to be a date filed like 06/08/2007. I have tried changing the field
property before and after import, appending the text filed to a new Date/Time
Field with no success. Is there an eaiser way than using left( ), right( ),
mid( )?
Any help would be appreciated....Thanks!
correctly except for the date fields. They import as text "06082007" and
need to be a date filed like 06/08/2007. I have tried changing the field
property before and after import, appending the text filed to a new Date/Time
Field with no success. Is there an eaiser way than using left( ), right( ),
mid( )?
Any help would be appreciated....Thanks!