Brian Gubb
|
| Posted: 11/17/2002, 3:42 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01C28E9B.61F53490
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can anyone tell me what formats I must have dates and times in an excel =
file, prior to importing them into MS Access 2000 database.
I'm able to read dates and times in a grid where data originated in =
excel 2000 but I'm stumped when it comes to updating these fields. I =
seem to have exhausted ever format combination.
In excel using =3Dtext(a1,"hh:mm") works, but I'd rather avoid having to =
change all the dates to text because I need to be able to sort dates, =
and text format wont sort in date order.
Anyone have a solution?
Brian
------=_NextPart_000_000A_01C28E9B.61F53490
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Can anyone tell me what formats I must have dates =
and times in=20
an excel file, prior to importing them into MS Access 2000=20
database.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm able to read dates and times in a grid where =
data=20
originated in excel 2000 but I'm stumped when it comes to updating these =
fields.=20
I seem to have exhausted ever format combination.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>In excel using =3Dtext(a1,"hh:mm") works, but I'd =
rather avoid=20
having to change all the dates to text because I need to be able to =
sort=20
dates, and text format wont sort in date order.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Anyone have a solution?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>
------=_NextPart_000_000A_01C28E9B.61F53490--
|
|
|
 |
Brian Gubb
|
| Posted: 11/22/2002, 11:35 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C292CB.54E1DD60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It was my silly mistake, I had a excel column called DATE and another =
one called TIME.
Brian
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ar7vb9$70m$1@news.codecharge.com...
Can anyone tell me what formats I must have dates and times in an =
excel file, prior to importing them into MS Access 2000 database.
I'm able to read dates and times in a grid where data originated in =
excel 2000 but I'm stumped when it comes to updating these fields. I =
seem to have exhausted ever format combination.
In excel using =3Dtext(a1,"hh:mm") works, but I'd rather avoid having =
to change all the dates to text because I need to be able to sort dates, =
and text format wont sort in date order.
Anyone have a solution?
Brian
------=_NextPart_000_0009_01C292CB.54E1DD60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>It was my silly mistake, I had a excel column called =
DATE and=20
another one called TIME.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ar7vb9$70m$1@news.codecharge.com">news:ar7vb9$70m$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>Can anyone tell me what formats I must have dates =
and times=20
in an excel file, prior to importing them into MS Access 2000=20
database.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm able to read dates and times in a grid where =
data=20
originated in excel 2000 but I'm stumped when it comes to updating =
these=20
fields. I seem to have exhausted ever format combination.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>In excel using =3Dtext(a1,"hh:mm") works, but I'd =
rather avoid=20
having to change all the dates to text because I need to be able =
to sort=20
dates, and text format wont sort in date order.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Anyone have a solution?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0009_01C292CB.54E1DD60--
|
|
|
|
|
