SQL Server Developer Center > SQL Server Forums > SQL Server XML > XML column imbedded into excel fromatted file
Ask a questionAsk a question
 

AnswerXML column imbedded into excel fromatted file

  • Monday, October 26, 2009 2:54 PMllb123 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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.



Answers

All Replies

  • Monday, October 26, 2009 3:13 PMwBobAnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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.
  • Tuesday, October 27, 2009 2:55 PMllb123 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

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