Hi - I have automated importing an Excel spreadsheet into Access. However, even though all the fields are formatted exactly the same some of the date fields import and some don't. Can anyone explain to me why this happens? And ..... how can I fix this? I actually linked the spreadsheet into the database and all the dates were present. If someone can tell me a quick an easy way to refresh the link so that any updates in the spreadsheet get captured in the database I would greatly appreciate it.
)))
)))