XML column imbedded into excel fromatted file

Question

Hello everyone,
I need to load excel formatted file with one xml column imbedded into it into the SQL server database staging table.
Does anyone know how this can be done?
Thank you.

Answer 1

Have you tried using SSIS?  Start with the Import Wizard ( eg from SSMS, right-click your database, Tasks, Import Data ... ).

This should at least give you a starting point.

Answer 2

Thank you.
SSIS did not help much, unfortunately.
However DMExpress did.