Importing text file with long datetime

  • Thread starter Thread starter Joe
  • Start date Start date
J

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!
 
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.
 
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!
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
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!
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top