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 |
|
muhiar
Starting Member
37 Posts |
 Posted - 2005-12-13 : 05:03:07
|
| hi all i am in a big problem ,i used the DTS in order to import msaccess 2000 table.the ms access table contains a date/time field with short time as format when i import it to the sql server table an error occurso how can i import the time data into sql server ??and my application will use the sql server instead of ms access in side the application i heavily depened on the current timehow sql server can handle it????any ideas thnx |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-15 : 07:29:21
|
| Two suggestions i woudl give1. When you use DTS, do you change the data types in the options given ?2. You can also use upsize wizard in access.However i prefer you stick to DTSAfrika |
 |
|
|
|
|
|
import time datatype from access to sqlserver 2000