Excel to Access Date Import Errors

Hi exp vg,

At least tell us what the exact error message is.  That way might get responses from people who aren't clairvoyant, also.

Also, what versions of Excel and Access are you using?

Access and Excel 2013

I get import errors for other fields, but not the date fields. However, in Excel it does appear in date format, but going to Access the date format is lost.

This may be the issue, but I am not sure how to undo it.

Some of the Excel date fields are self-standing dates - i.e. 1/24/1994

However, some of the other excel dates are sub-categorized by year (i.e. 1994) and then month (January).

Please offer the most efficient way to make all Excel dates into one consistent format.

I have tried selecting the entire Excel column, and then changing the format to date, but this is not working.

Thanks.

In my last post I asked: "At least tell us what the exact error message is.".  What is it?

> I get import errors for other fields, but not the date fields.
So you don't get import errors for the date fields.  I'm confused.

Yes, you are correct, I get file conversion errors for the zip code, but not date. However, not all the date cells are imported correctly. As mentioned in my last post, I have an initial take that it may be due to how the dates are stored in Excel.

It does have to do with how the dates are cateorized/stored in Excel. I separated them out, and the dates that are not under subcategories (i.e. - 1995, January) are able to import successfully.

Therefore, the dates need to be in a single, non-categorized format.