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

storing a string data in access

P: n/a
Hi
I have
access.Fields("Time").value=t
I would like t to be a string reprsenting a data. How can I do this?
Nov 2 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Nov 3, 3:47*am, "tedpot...@gmail.com" <tedpot...@gmail.comwrote:
Hi
I have
access.Fields("Time").value=t
I would like t to be *a string reprsenting a data. *How can I do this?
t = "string representing a datum"
access.Fields("Time").value = t
Nov 3 '08 #2

P: n/a
"alex23" <wu*****@gmail.comwrote in message
news:fc**********************************@t18g2000 prt.googlegroups.com...
On Nov 3, 3:47 am, "tedpot...@gmail.com" <tedpot...@gmail.comwrote:
>Hi
I have
access.Fields("Time").value=t
I would like t to be a string reprsenting a data. How can I do this?

t = "string representing a datum"
access.Fields("Time").value = t
maybe OP means t = "string representing a date", but I'm just guessing.

--Tim Arnold
Nov 4 '08 #3

P: n/a
On Nov 4, 3:53*am, "Tim Arnold" <tim.arn...@sas.comwrote:
"alex23" <wuwe...@gmail.comwrote:
t = "string representing a datum"
access.Fields("Time").value = t

maybe OP means t = "string representing a date", but I'm just guessing.
Oops, that totally didn't occur to me. You'd think the field's key
would've been a giveaway :)

ted: take a look at the time module, it's part of the standard
library.

import time
access.Fields("Time").value = time.strptime('10:00AM', '%I:%M%p')

http://www.python.org/doc/2.5.2/lib/module-time.html
Nov 4 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.