Changed dates after Import

[Gretchen]

We imported data from Excel into Access. The dates that were 2003 and 2004 in Excel changed to 2002 when the Access database was opened. This has happened twice. It takes a great amount of time to correct this. Can anyone tell me what happened? I didn't do these imports and don't know if something was done by the "expert" who did this. HELP!!! Thanks for the help .. I really appreciate it

 

[Pat Hartman]

I would do the import again. Make sure that the column where the dates are in the spreadsheet is defined as Date rather than General. Also, make sure that the column in the table where you are appending the date is defined as Date.

 

[Gretchen]

Thanks so much for replying! The dates have already been changed to reflect the correct years, so I won't be importing again. However, I think you have hit the problem. Knowing the users of the Excel sheets, I am sure they didn't change the date column to format as date; but left it as general. Therefore, when I changed the Access table to have that be a date so that I manipulate letters and reports using that field, it probably "messed up" then.

Thanks ... I'll be sure that any imports that I do, the columns and fields are the same.