Query Problem

  • Thread starter Thread starter DSTDIVA3
  • Start date Start date
D

DSTDIVA3

I am linking to an excel table. When I open the table, all the data is
there. One of the columns contains the date and time. When I query the
table, the date column is null. Does anyone know what is causing this
problem and what could be the solution?
 
Probably the date in excel isn't a real date that can be interpreted as a
date by acces or it is a textfield.

rgds. Martin
 
The field contains both the date and time (i.e. 6/7/2007 12:32 PM CST). Any
suggestions....
 
The inclusion of CST on the end means that Access will not see this as a
valid date.

If you don't need the CST you could try removing the CST off all the fields
that contain it and then Access should be able to recognize the data
correctly. Do you have other time zones appended? If so you may have to
work out a method of converting the times to universal time and recording
the time zone in a separate field.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
That works. Thanks

John Spencer said:
The inclusion of CST on the end means that Access will not see this as a
valid date.

If you don't need the CST you could try removing the CST off all the fields
that contain it and then Access should be able to recognize the data
correctly. Do you have other time zones appended? If so you may have to
work out a method of converting the times to universal time and recording
the time zone in a separate field.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Back
Top