asked on

Importing an excel file with a problematic date column

Hi,
I have an excel file (attached ) with one column.
the problem is that this column have defferent formatting for a date.
this what i`m getting from external apps as export.

now i`d like to import this file into access.
but when i do that. it doesn`t recognize the column as a date , but as i text.which i don`t want to.
that`s because of the problem with the format.
how can i import the column as a date (fixing the problem through the importing process in access) , if one may help out , maybe using a vba code . or somethen:}
thnx in regard :}
DateProblem.xlsx

Rey Obrero (Capricorn1)

import the excel file to a temp table.
use a query to format the dates imported to the temp table and append the result to the destination table.

what date format do you have in your destination table?

drtopserv

ASKER

dd/mm/yyyy
but how can i use a query to format it?
may a sample?

Rey Obrero (Capricorn1)

select cdate(format([datefield],"dd/mm/yyyy"))
from temptable

drtopserv

ASKER

but did you see the column in the excel file, it has 2 formats togother in same column

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.