Problem Importing records with Date/Time data type into an Access 2007 data table

C

Cillacil

Joined
Apr 3, 2009
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Pivot table macro filter data between yesterday and today (date+time) 0
Importing date problems in CSV 1
Help on Importing a Date/Time Data Type 4
Problem importing dates 3
Importing Fixed Length File into Access 2007 1
Importing records that include dates from Excel into Access 1
how to change data type while importing 1

Top