G
Guest
I am having trouble with one date column when importing an excel file into
access. The problematic column is formatted as "date" in excel (the exact
same way as another date column in this particular excel file) however, when
I import it into the access table the date column is converted to text and
only about 20 of the 400 rows have a valid date entry. All the other rows
have the text version of the date - when I try to convert the entire column
in access to a "date" column (instead of text) all the text formed dates are
deleted.
Any thoughts on how to fix this?
access. The problematic column is formatted as "date" in excel (the exact
same way as another date column in this particular excel file) however, when
I import it into the access table the date column is converted to text and
only about 20 of the 400 rows have a valid date entry. All the other rows
have the text version of the date - when I try to convert the entire column
in access to a "date" column (instead of text) all the text formed dates are
deleted.
Any thoughts on how to fix this?