Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / September 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mscertified - 14 Sep 2007 18:10 GMT
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.
Ken Snell (MVP) - 14 Sep 2007 20:29 GMT
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_threa
d/thread/c3d819abfca3e0d7/bf88e623a3bbeccd


Let us know if that doesn't help.
Signature


       Ken Snell
<MS ACCESS MVP>

>I have a user who is importing Date time values via the wizard. Every row
>is
[quoted text clipped - 3 lines]
>
> Thanks.
 
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.