Urgent for Jeff Conrad help pls....

[Guest]

So does it mean conclusion that its best that i don import the data from
Excel...as i cannnot change the data type from "Text" to Date/Time??

coz there;s a whole lot of data that i need to transfer like names and
stuff......it would take a huge time.....could i transfer only columns that
uses "Text" data type .....while the "Date" i'll make a new column in it and
key in manually....??

I'm really so confused and headache now......

Even the date...i want it to be DD/MM/YYYY....and that;s how i key in the
"format" for the data type....so some of them still appear like
MM/DD/YYYY......while some stays how i wanted......

 

[Douglas J Steele]

Date/Times in Access (and Excel, for that matter) don't have a specific
format: they're stored as 8 byte floating point numbers, where the integer
portion represents the date as the number of days relative to 30 Dec, 1899,
and the decimal portion represents the time as a fraction of a day.

You might find it useful to read Allen Browne's "International Dates in
Access" at http://members.iinet.net.au/~allenbrowne/ser-36.html or what I
have in my September 2003 Access Answers column for Pinnacle Publication's
"Smart Access" newsletter. The column and accompanying database can be
downloaded at http://members.rogers.com/douglas.j.steele/SmartAccess.html

If you're importing the data from Excel, and you're unable to do the
conversion from Text to Date during conversion, you can always add a Date
field to your table after the fact and run an Update query to populate that
Date field from the Text value.

Even if you're linking to Excel, you should be able to add a computed field
to a query that uses the CDate() or DateValue()functions to give you a Date
field that you can use for other purposes.