TSQL Convert SQL smalldatetime to string for MS Access Date/Time
I have a stored procedure which collects a recordset which populates and array. This array array in turns loops and populates an MS Access 2007 Database table.
Everything goes well right up to 'Report_DC' (Date Created). This either copies poorly or not at all. There are no NULL's all the reports have a value for this field which look like this: 2012-11-02 17:38:00
I have tries
, CAST (rpt.Report_DC as varchar)
but it does not work. When I open the Access table I get 'XXXXXXXXXXXX'