Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Arnold
Starting Member
5 Posts |
 Posted - 2005-02-03 : 12:48:50
|
| Hi, all, I have a datetime field in one of my SQL tables that returns in the following format when selected in Query Analyzer:2003-05-19 10:40:07.660 (This is an example.)I want to export this table to Microsoft Access; however, I cannot figure out how to get Access to preserve the milliseconds.Any solutions? |
|
|
bmains
Starting Member
27 Posts |
Posted - 2005-02-03 : 13:14:49
|
| I tried to enter the date as is in to access, but it wouldn't take it. I'm guessing it doesn't support milliseconds in dates. Enless you store it in another field.Brian |
 |
|
|
BammBamm
Starting Member
9 Posts |
Posted - 2005-02-04 : 15:45:24
|
| I have the same conlusions as bmains... I don't think its' supported. Funny, the field size is the same as on SQL.Options -(1) Store ms in other field (like bmains suggests)(2) Store entire value as text (23 chars), which could be a hassle if you intend to do date/time calcs. |
|
|
|
|
|
|
SQL Export to Access, Preserve Milliseconds