Importing text file with long datetime

[Joe]

I'm trying to import a Unicode text file containing long
datetime values into an Access project file. As an
example: "7/3/2004 11:19:00 PM"

When I try to import like values into a datetime column,
the Access error table has the following error
message: "Type Conversion Failure".

Anyone have any idea how to fix this? Thanks!

 

[John Nurick]

Hi Joe,

Import it to a text field and then use the CDate() function in a query
to convert the string to a date/time value.

 

[Joe]

Hi John,

Thanks for the help on this subject. I figured I could
import the datetime as a text field and convert later,
which I did. But I was wondering if I was doing something
wrong during the import process. Is this normal for
Access not to import long datetime values?

Thanks again for you help.

-----Original Message-----
Hi Joe,

Import it to a text field and then use the CDate() function in a query
to convert the string to a date/time value.

I'm trying to import a Unicode text file containing long
datetime values into an Access project file. As an
example: "7/3/2004 11:19:00 PM"

When I try to import like values into a datetime column,
the Access error table has the following error
message: "Type Conversion Failure".

Anyone have any idea how to fix this? Thanks!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Hi Joe,

I'm not sure whether I'd call it "normal", but it's certainly common.

Hi John,

Thanks for the help on this subject. I figured I could
import the datetime as a text field and convert later,
which I did. But I was wondering if I was doing something
wrong during the import process. Is this normal for
Access not to import long datetime values?

Thanks again for you help.

-----Original Message-----
Hi Joe,

Import it to a text field and then use the CDate() function in a query
to convert the string to a date/time value.

I'm trying to import a Unicode text file containing long
datetime values into an Access project file. As an
example: "7/3/2004 11:19:00 PM"

When I try to import like values into a datetime column,
the Access error table has the following error
message: "Type Conversion Failure".

Anyone have any idea how to fix this? Thanks!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.