Re: Export dataset to Ms Access .mdb file

[Lucedoriente]

Re: Export dataset to Ms Access .mdb file

 

Hi, to everyone. I have a problem exporting my XML file with an error:

System.Runtime.InteropServices.COMException not handled

ErrorCode=-2147467259

Message="La dimensione di un campo è eccessiva. "

translated is more or less: the size of a field is too big

Source="Microsoft JET Database Engine"

 

I use VS 2008 and use as reference:

Microsoft ADO Ext. 6.0 for DDL and Security (Interop.ADOX) 6.0.0.0

adodb.dll 7.0.3300.0

 

I use as string field a lot of nvvarchar(max) that my XML translate in

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="2147483647"/>

</xs:restriction>

</xs:simpleType>

 

I attach my XML, can someone please help me?

Perizia.zip

Edited November 20, 2010 by snarfblam