Data and Time convertions - TRICKY!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert EML to PST? 2
How to Convert EML to PST in 2025? 2
How can we convert OST to PDF file format? 1
Type Conversion Error While Importing (Time Field) 8
Combining IF Statement and Vlookup 0
Convert Date and Time 9
Convert a csv to xls prior to import 2

Back
Top