Importing text file with long datetime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 25 Aug 2004 22:30 GMT

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!

Reply to this Message

John Nurick - 25 Aug 2004 22:48 GMT

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
[quoted text clipped - 5 lines]
>
>Anyone have any idea how to fix this? Thanks!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Joe - 26 Aug 2004 00:52 GMT

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,
[quoted text clipped - 17 lines]
>Please respond in the newgroup and not by email.
>.

Reply to this Message

John Nurick - 26 Aug 2004 06:21 GMT

Hi Joe,

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

>Hi John,
>
[quoted text clipped - 30 lines]
>>Please respond in the newgroup and not by email.
>>.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message