We cannot convert the value "System Host Name: MI …." to type Table Importing XML File

[DebbieE]

Ive Loaded in an XML file which seems really complex and its taken ages to open up all the  hierarchies to get to all the columns. However when I try and save I see the error

OLE DB or ODBC error:[Expression.Error] We cannot convert the value “System Host Name: MI ….” to type Table..

I dont know what the error is relating to, which column? all columns ? I dont know how to get past this issue.

Any help would be appreciated. Ive  getting so many issues tryng to import these XML files

[v-yulgu-msft]

Hi @DebbieE,

Please check the applied steps one by one to see what operation caused such an error. Also, what is the detailed error message?

Regards,

Yuliana Gu