Tony (bluestealth94 (AT) hotmail (DOT) com) writes:
Quote:
I am trying to append from Access to a SQL Server table - one record.
I am told the problem is because of the OLE datatype in the sql table.
We used to be able to do it but for the last few years the sql server
has not let us. Does anybody have any ideas on what can be the cause
of this problem? |
I think this question is better asked in an Access forum. They might
know what the "OLE datatype" is. All I know is that there is no such
type in SQL Server.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx