Query Problem

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?
 
M

Martin Bakker

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
 
D

DSTDIVA3

The field contains both the date and time (i.e. 6/7/2007 12:32 PM CST). Any
suggestions....
 
D

DSTDIVA3

Yes all the fields are text fields, but it shows the format for the date and
time.
 
J

John Spencer

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
..
 
D

DSTDIVA3

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...
 
Top