Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Import/Export Data
Problem with date when importing Problem with date when importing
Register Blogs FAQ Members List Social Groups Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-26-2010, 05:03 PM
ds_8805 ds_8805 is offline Windows XP Access 2002 (version 10.0)
Novice
  
Join Date: Jan 2010
Posts: 27
ds_8805 is on a distinguished road
Default Problem with date when importing
Hello! I am trying to import an excel file to access. I have managed to import successfully. However, my date column is in the excel spreadsheet which looks as such eg 4-Feb-09 is changed to 4/2/09 in access after it has been imported. I have tried to keep the date's column as text datatype or datetime datatype. But both does not work. Hope someone could clear my doubt. Thks!! Any help is appreciated.
Reply With Quote
  #2  
Old 01-26-2010, 10:41 PM
Rainlover Rainlover is offline Windows XP Access 2003 (version 11.0)
Competent Performer
  
Join Date: Nov 2009
Posts: 173
Rainlover is on a distinguished road
Default
You need DateTime.

Then change the format to whatever you want.
Reply With Quote
  #3  
Old 01-26-2010, 10:48 PM
ds_8805 ds_8805 is offline Windows XP Access 2002 (version 10.0)
Novice
  
Join Date: Jan 2010
Posts: 27
ds_8805 is on a distinguished road
Default
I have used DateTime datatype. However it still does not work
Reply With Quote
  #4  
Old 01-26-2010, 11:20 PM
Rainlover Rainlover is offline Windows XP Access 2003 (version 11.0)
Competent Performer
  
Join Date: Nov 2009
Posts: 173
Rainlover is on a distinguished road
Default
What format you you have?
Reply With Quote
  #5  
Old 01-26-2010, 11:26 PM
ds_8805 ds_8805 is offline Windows XP Access 2002 (version 10.0)
Novice
  
Join Date: Jan 2010
Posts: 27
ds_8805 is on a distinguished road
Default
actually I just managed to solve this problem..I realised I din set the format properly. Thanks for ur help.
Reply With Quote
  #6  
Old 01-26-2010, 11:30 PM
Rainlover Rainlover is offline Windows XP Access 2003 (version 11.0)
Competent Performer
  
Join Date: Nov 2009
Posts: 173
Rainlover is on a distinguished road
Default
Glad you got it.
Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing html data - Carriage Return Problem MichelleNZ Import/Export Data 1 11-26-2009 02:13 PM
Date Problem oldteddybear Queries 1 08-30-2009 06:52 AM
Problem with date field... Rameez Access 9 06-23-2009 08:29 AM
Showing date and time when importing to access timpepu Import/Export Data 0 05-07-2009 05:13 AM
Big ol' Access problem (Forms, Macros, Importing, Query, etc FlyinBrian Access 0 03-27-2008 06:20 AM


All times are GMT -8. The time now is 08:29 PM.

Contact Us - Top

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.