Date & Time Field

[Atreju]

I have the need to import logs into an Access table.
The first field is a date & time field, represented in this example:

05/15/2004 17:58:55.336

This is how the logs are reported. Date[SPACE]Time. The time is to 3
decimal points of the second.

Access is not letting me import this into the Date & Time field.

Is there a way to get the Date & Time field to allow 3 decimal places
after the seconds?

My only alternative is to make an ID field and have it
programmatically pull the date, time and then append that number with
the 3 digits after the decimal, to insure a unique number.

Please advise.
---Atreju---

[PC Datasheet]

Change the design of your table to:

TblLog
LogID
LogDateTime

Make LogID autonumber and let Access assign its value automatically.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Atreju" <so*****@who.hates.junkmail> wrote in message
news:m2********************************@4ax.com...

I have the need to import logs into an Access table.
The first field is a date & time field, represented in this example:

05/15/2004 17:58:55.336

This is how the logs are reported. Date[SPACE]Time. The time is to 3
decimal points of the second.

Access is not letting me import this into the Date & Time field.

Is there a way to get the Date & Time field to allow 3 decimal places
after the seconds?

My only alternative is to make an ID field and have it
programmatically pull the date, time and then append that number with
the 3 digits after the decimal, to insure a unique number.

Please advise.
---Atreju---

[Pieter Linden]

Atreju <so*****@who.hates.junkmail> wrote in message news:<m2********************************@4ax.com>. ..

I have the need to import logs into an Access table.
The first field is a date & time field, represented in this example:

05/15/2004 17:58:55.336

This is how the logs are reported. Date[SPACE]Time. The time is to 3
decimal points of the second.

Access is not letting me import this into the Date & Time field.

Is there a way to get the Date & Time field to allow 3 decimal places
after the seconds?

what about putting the fractions of a second into another field?

[Atreju]

On Sun, 08 Aug 2004 17:52:27 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Change the design of your table to:

TblLog
LogID
LogDateTime

Make LogID autonumber and let Access assign its value automatically.

The problem with that is I would like to make the Date/Time become the
primary key. There will never be duplicates of that.

I suppose what I could do is what you suggest, or some variation
thereof, but I was really looking to find out whether I could do a
direct import into that field. Apparently I will have to
programmatically change the data of each record or at least add to it
based on the contents. This is going to be using a Visual Basic
application as the front-end to the database, so I will have to do
something like that.

Thanks for the info.
---Atreju---