Data and Time convertions - TRICKY!!!

H

hackerjjj

I have a csv text file that is an export from a proxy server and the first
column is a data/time conversion. I would liek to convert the data and then
the time into two seperate columns.on e data and the other time.

The format of the csv is::

6/1/2007 17:02

Just want to pull this column to the Access two coluumns. Any improtmet.

Thanks in advance

Ron
 
D

Douglas J. Steele

Why do you want it in two fields? That's seldom a good idea: it makes
comparisons much more difficult. My advice would be to keep it in a single
field, and create a query based on the table. In the query, you can use the
DateValue and TimeValue functions to create two computed fields representing
the Date and Time values respectively. You can then use the query wherever
you would otherwise have used the table.

If you're insistant that they be two separate fields, import the data into a
temporary table, and create the query as suggested above, and use that query
as the basis of a Make Table query.
 
Top