Text output of a date/time field

B

Bob Richardson

I want to convert a date/time field to a text field so that I can import the
XLS file into a table in Access. This is because I want to have my time
field in the Access DB sometimes store an actual text (like "Lunch") rather
than a time. If I force the first few records to have some text in the time
field, then Access imports the time data like "1/1/1900"

I want to end up with all text in the time field, not a date/time value. Is
there a Paste Special or some other way to get this info into text?
 
R

Ron Rosenfeld

I want to convert a date/time field to a text field so that I can import the
XLS file into a table in Access. This is because I want to have my time
field in the Access DB sometimes store an actual text (like "Lunch") rather
than a time. If I force the first few records to have some text in the time
field, then Access imports the time data like "1/1/1900"

I want to end up with all text in the time field, not a date/time value. Is
there a Paste Special or some other way to get this info into text?
Click to expand...

Look at the TEXT worksheet function. It will return a text string, formatted
as you like.


--ron
 
Top