By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,499 Members | 829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,499 IT Pros & Developers. It's quick & easy.

Date & Time Field

P: n/a
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---
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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---

Nov 13 '05 #2

P: n/a
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?
Nov 13 '05 #3

P: n/a
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---
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.