vba - How to Import XML to MS Access with Memo Data Type? -

i'm having error while using code:

application.importxml filename, acappenddata 

by default, creates "relevantresults" table "text" datatype. not of data imported because truncated.

i'm thinking of creating table 1 of field memo data type , append xml. how should when create new table "relevantresults"?

how should define table used?

if access destination table exists, importxml acappenddata parameter preserves structure of table. adds xml data table, assuming data compatible table fields' data types.

create relevantresults table memo data type need it, run importxml fill table.