When importing data into an Access 2000 table, the formerly as number or date/time formatted fields change back to text. Date/time data is then only recognised as text when running a query, causing problems when data is copied over to Excel and reports are created (times cannot be added up etc.). Any idea what I or Access is doing wrong?
Thanks. Olav