Hello UA, new user here. Thanks in advance for your input. Working with Access 2007.

I'm working on a database that will be importing approximately 200,000 entries per day from a text file. One of the columns includes a date and time stamp formatting YYYYMMDD 12:00. For the purpose of the database I don't need the time information, I just need the date to be imported, I really don't need the time information so if there was a way to exclude that that would be great. When I did try import that file I went under the advanced tab to change the information type from Text to Date/Time and it gave me an error message which left that column blank in my table.

Basically 2 questions:

Is it possible to remove the time entry in my data before importing it into access? (maybe with excel)

If not, who do I import from my text file and display just the date information?

Formating looks like this delimited by tabs: YYYYMMDD 12:00 example: 20120402 09:05

I really appreciate the help.

(IMG:style_emoticons/default/welcome2UA.gif)

When I am faced with a situation like this I usually import the text file into a transition table, then format it over to my "real" table. This can be automated (VBA) with 1) a query to clear the transition table, 2) import the text file into the transition table, 3) transfer the transition table records to the main table with an append query. The DateTimeStamp text field itself can be transferred to a date field in the main table with something like this in the query:



...using your correct field names, of course.

HTH
Joe

Or you can use this expression which will import a date/time value with the date only:

DateValue(Format(TimeStampString, "!@@@@/@@/@@"))

/gustav

Thank you both very much!

(IMG:style_emoticons/default/yw.gif)