 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2007Query Problem
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 > 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? The field contains both the date and time (i.e. 6/7/2007 12:32 PM CST). Any suggestions.... > Probably the date in excel isn't a real date that can be interpreted as a > date by acces or it is a textfield. [quoted text clipped - 5 lines] > > table, the date column is null. Does anyone know what is causing this > > problem and what could be the solution? Yes all the fields are text fields, but it shows the format for the date and time. > The field contains both the date and time (i.e. 6/7/2007 12:32 PM CST). Any > suggestions.... [quoted text clipped - 8 lines] > > > table, the date column is null. Does anyone know what is causing this > > > problem and what could be the solution? 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.  SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . > Yes all the fields are text fields, but it shows the format for the date > and [quoted text clipped - 17 lines] >> > > this >> > > problem and what could be the solution? That works. Thanks > The inclusion of CST on the end means that Access will not see this as a > valid date. [quoted text clipped - 26 lines] > >> > > this > >> > > problem and what could be the solution? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.