Converting Ms Access to SQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Converting Ms Access to SQL

I am trying to convert a MS Acess database to SQL and get the following error message on two different tables when I use the Inport Export Data function on the Microsoft SQL Server: Insert error, column 8 (‘session-time’, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification. The column in one table is a time field and in the other table is a date field. The date field has null values. I think the format of the fields in MS Access is causing the problem…. Help!
Refer to this link http://www.sqldts.com/default.aspx?6,103,249,0,1] for information and resolve the issue using DTS for datetime stamps. _________
Satya SKJ

Thank you for your help Satya, I am going to try it now…..
]]>