Date Format in SQL (MSDE)

Hi,
Can anyone help with the following:
I am importing a XML file into a SQL (MSDE) database table, and one
field is set as follows:
01/11/2005 00:03:33.18
01/11/2005 00:04:31.12
01/11/2005 00:10:06.32
01/11/2005 00:12:20.59
01/11/2005 00:00:56.66
I am using access to manage MSDE, and when I go to the table design and
try to format this field as "General Date" or any other pre-set date
format, it give the "Access encountered an error" message and then
deletes everything in that field.
Does anyone know how I can format the above time format into something
that will work with MSDE?
Thanks in advance for any help.
Thanks
H01/11/2005 00:03:33.18 works on SQL Server but not in Access.
Access only recognizes seconds (00:00:00 to 23:59:59) so 01/11/2005 00:03:33
will work.
If you need miliseconds perhaps you can use another tool.
Ben Nevarez
<harrys@.gmail.com> wrote in message
news:1131930009.458433.191620@.g43g2000cwa.googlegroups.com...
> Hi,
> Can anyone help with the following:
> I am importing a XML file into a SQL (MSDE) database table, and one
> field is set as follows:
> 01/11/2005 00:03:33.18
> 01/11/2005 00:04:31.12
> 01/11/2005 00:10:06.32
> 01/11/2005 00:12:20.59
> 01/11/2005 00:00:56.66
> I am using access to manage MSDE, and when I go to the table design and
> try to format this field as "General Date" or any other pre-set date
> format, it give the "Access encountered an error" message and then
> deletes everything in that field.
> Does anyone know how I can format the above time format into something
> that will work with MSDE?
> Thanks in advance for any help.
> Thanks
> H
>|||Hi Ben.
Problem is, that if I try and covert it to the 00:00:00 format, access
doesn't like that so it just deletes all the records!
And at the moment there is no other way to get the XML file, apart from
with those miliseconds in there.
H
Ben Nevarez wrote:
> 01/11/2005 00:03:33.18 works on SQL Server but not in Access.
> Access only recognizes seconds (00:00:00 to 23:59:59) so 01/11/2005 00:03:
33
> will work.
> If you need miliseconds perhaps you can use another tool.
> Ben Nevarez
>
>