Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Tue Oct 14 14:34:22 CDT 2003
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