C# OleDBException datatype not matched when copying table from MSSQL 2005 Express to MS Access 2016

Question

MS-SQL 2005 DataType CREATE TABLE consultation(Id int NOT NULL IDENTITY(1,1) PRIMARY KEY, person nvarchar(300), consultationid int, personname nvarchar(3000), visitdate DATETIME, phonenumber nvarchar(2000), consultation nvarchar(4000)

MS-Access 2016 DataType CREATE TABLE consultation([Id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [person] TEXT(50), [consultationid] int, [personname] TEXT(50), [visitdate] DATETIME, [phonenumber] TEXT(100), [consultation] LONGTEXT

I've created SQL2005 and Access2016 tables as above shown. And when I try to copy table from SQL 2005 to Access 2016 through C# OleDBCommand with making a DataTable, OleDBException datatype not matched is shown.

In case like this, what should I consider & fix ?

Many thanks for your kind excellence !

Answer 1

but the actual data inside are smaller than 50.

The data provider/components can't guess the may max size of the data in the source file.
Table definition source+destination must (!) match.

Answer 2

person nvarchar(300) ... personname nvarchar(3000),
[person] TEXT(50) ... [personname] TEXT(50),

Now guess, why you get a mismatch error; the column sizes absolutly don't match.