Community discussion forum

XML FILE IMPORT TO SQLSERVER

• • Reply

  3 months ago

  by shalinijennifer

  shalinijennifer

  , India

  Joined 1 year ago

  Hi 

   

  How to import an xml file to sql server database thro code in vb.net

   

  Thanks in Advance

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  3 months ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 1 year ago

  Maybe you can write a SQL stored procedure that accepts the contents of your file as an input parameter.
  
  Within your stored procedure, you can use the OPENXML command to parse your XML and insert it into your tables.
  
  http://msdn.microsoft.com/en-us/library/aa276847(SQL.80).aspx
  
  

  Report abuse