Taking 10 lefthand characters in a cell
 

Hi,

I have a column in excel which I am trying to import into access.
However I am trying to do this as a date but the columns entries are
like the below;

09/14/06 19:22:47

This causes an error in access.

So i presumed I could in the next column use the left formula to create
a column that only showed the date part of the entry and omitted the
time. This doesn't work - no matter how I format the cell I get an
entry in the new cell as something like 38974.8074

Where am I going wrong?

Also - Having 2 columns showing the date will be a problem for my
import. (I will not be able to hide the original column as this will
still appear during import). I cannot delete the original column as
then my new column will not work. Is there another way of doing this at
all?

Taking 10 lefthand characters in a cell
 

keri wrote:
Hi,

I have a column in excel which I am trying to import into access.
However I am trying to do this as a date but the columns entries are
like the below;

09/14/06 19:22:47

This causes an error in access.

So i presumed I could in the next column use the left formula to create
a column that only showed the date part of the entry and omitted the
time. This doesn't work - no matter how I format the cell I get an
entry in the new cell as something like 38974.8074

Where am I going wrong?

Also - Having 2 columns showing the date will be a problem for my
import. (I will not be able to hide the original column as this will
still appear during import). I cannot delete the original column as
then my new column will not work. Is there another way of doing this at
all?

=TRUNC(A1) returns only the date part of a date with time in A1

Ken Johnson

Taking 10 lefthand characters in a cell
 

What an amzing person you are - I can't believe I had never heard of
this before! Thanks.