Having problems with Importing using Data Transformation Services to import a table from an Access DB to an existing DB in SQL Server 7.0. The particular field is, of course, a date field. In Access, it is a date/time field with a format of Short Time. In SQL, it is a datetime field (standard). When I run the DTS - it only takes the date portion of the field, and only shows up as 08/29/ instead of the full date and time.<BR>Any ideas how I can do this and have it show either just the time in SQL or the date and time? I need to use DTS in order to have this work on a weekly basis.<BR>Thanks in advance!<BR>-L