[AccessD] Import Excel Dates into Access

Oleg_123,

Thanks for the reply.  I went ahead and implemented your
suggestion...setting the destination field format to Short Date.  When the
format is set to General Date the previous records do not have a time
component.  Does the "Short Date" approach have any negative implications?
Could it cause any impact to date calculations used in criteria?  I hope
not...


Mark

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Tuesday, October 14, 2003 3:34 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Import Excel Dates into Access


Mark,

what about importing/linking the excel data to access and setting Data Type
- Date/Time, Format - Short Date  ?

> I just received an Excel spreadsheet with a date column.  The dates 
> display as "8/22/2003", however the cell contains "8/22/2003  2:00:00 
> PM".  How can I import this data into Access retaining only the date 
> "8/22/2003"?  Prior to this submittal I could link to the spreadsheet 
> and copy/paste the records with no massaging of data required.  They 
> obviously have changed their export routine.
>
>
> Mark
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com