Re: Importing Date/Time data via the wizard. How???

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
Date: Fri, 14 Sep 2007 15:29:19 -0400

There was an earlier post about this in which I was involved...let me see..
ok, here it is. See this link:
http://groups.google.com/group/microsoft.public.access.externaldata/browse_thread/thread/c3d819abfca3e0d7/bf88e623a3bbeccd

Let us know if that doesn't help.
--

Ken Snell
<MS ACCESS MVP>

"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:EAD5E4C5-6600-4A31-B5FE-8453CB703432@xxxxxxxxxxxxxxxx

I have a user who is importing Date time values via the wizard. Every row
is
generating a 'type conversion failure'. The dates are in the form
mm/dd/yyyy
hh:mm AM/PM. Can this be done, and if so, how?

Thanks.

Prev by Date: RE: Splitting Database and using Excel as a front.
Next by Date: Re: need to import to access the header row with each subsequent data
Previous by thread: getting data from a shopping cart mysql database
Next by thread: Re: need to import to access the header row with each subsequent data
Index(es):
- Date
- Thread

Relevant Pages

Re: display a date
... Set the Format property of the field to mm/dd/yyyy (or, if outside US, ... dd/mm/yyyy). ... Ken Snell ... <MS ACCESS MVP> ...
(microsoft.public.access.forms)
Re: Birthday Lists in MS Access
... MS Access MVP ... > I am using short date format (MM/DD/YYYY) in MS Access ... > but all I get is a complete listing of all birthdays. ...
(microsoft.public.access.queries)