I'm trying to import data from a MySQL tabel with the following statement
INSERT INTO [TABEL1].DATE
FROM OPENQUERY(MYSQL_DATABASE, 'SELECT CONVERT(NVARCHAR,DATE) FROM mysql_tabel')
In plain text: I want to import dates (fieldtype: date) form MYSQL AS TEXT into a MSSQL field.
It doesn't work and i get a big errormessage:
[Microsoft][ODBC SQL Server DRIVER][SQL server]OLE DB error trace [OLE/DB Provider 'MSDASQL'IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not give any informatie about the error.]
May be it has something to do with an older MySQL driver version?
I won't you bother with the reasons why, but how do I convert dates into text form MySQL into MSSQL?