I am trying to import some data from a text file in to an Access database I am creating. The fields that I am having trouble with are Date-Time format. Those fields will not import. This is their format (11/1/2008 8:34:00 AM). Then I need calculate times between the dates. The dates are coming from a text file. The only way I can get them to import is to change the field properties to Text. But when I do that, I cant perform calculations on those fields. I have to manually go back into the field properties and change them to Date/Time, General format.
Problem Importing records with Date/Time data type into an Access 2007 data table
- Thread starter Cillacil
- Start date