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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Datatype mismatch error--Help????

Author  Topic  reidcor Starting Member 1 Post Posted - 2005-05-09 : 12:37:24 Hi, I'm new on this forum, thanks in advance for looking... I have an Access database table with rows I'm trying to transform and add into an existing SQLServer table. The tables both have a 'datetime' column and that is my problem. In the DTS Import Wizard, when I choose "all rows" in the query builder phase, I get a good transfer of rows. But when I choose criteria to get a "WHERE..." statement, using the Access table's 'CurrentEndDate' column to choose criteria value, it looks like this: WHERE [accesstable].'CurrentEndDate'>='05/06/2005' ...and I get the error message stating that I have a datatype mismatch in criteria expression. If I use other operands such as '>', '<', etc. I still get the same error. I have two questions about this: 1. My premise on this is that since the rows transfer when I don't put in the "WHERE..." statement, the problem is not with the data but in the syntax that Import Wizard uses to build the "WHERE..." clause. Is this correct, and if so, what can I do to repair the statement? 2. What I'd REALLY like to do is have a WHERE statement that pulls the rows added since the last time the package was run, if anyone has a suggestion on how to do that? Thx much, Reid C.