Time field conversion to SQL 2000

[Magnus]

I have an Access 2000 db that I want to upsize to SQL
server 2000. Some fields are of date/time data type and
show only time in hours and minutes, These fields will
not convert. What should I do??? (Fields of date/time
type that show short date will convert.) Thanks a M for
your help.

Magnus

 

[Joe Fallon]

Add a phony date to them.
Usually the system minimum is used.
(Sometimes the max.)
Depends on what you need.

Once the data is stored in SQL Server you can still display just the hours
and minutes.

Actually,
Access *does* store the date/time field with a date. So you may not be
displaying it but it is there.
(Unless the data type in Access isn't date/time at all but Text.)
So they should convert.

 

[Magnus]

Thanks!

Will try that.

Take care!

Magnus

-----Original Message-----
Add a phony date to them.
Usually the system minimum is used.
(Sometimes the max.)
Depends on what you need.

Once the data is stored in SQL Server you can still display just the hours
and minutes.

Actually,
Access *does* store the date/time field with a date. So you may not be
displaying it but it is there.
(Unless the data type in Access isn't date/time at all but Text.)
So they should convert.
--
Joe Fallon
Access MVP






.