Post reply

Importing XML files into SQL Server 2005 table

  • August 5, 2008 at 1:45 am

    #190447

    Hi All,

    Can anyone plz let me know how can i import XML files into Sql server tables using Import/export wizard or any other easy methods for importing XML files.

    Thanks in advance.

  • August 5, 2008 at 2:18 pm

    #853484

    you can use import and export wizard...you can find this wizard in BIDS...you just follow that wizard starting with the selection of source for MicrosoftExcel..It takes you to the end of the wizard...you just need to give the server names and source and destination...

  • August 5, 2008 at 7:14 pm

    #853578

    I want to import XML file not an excel file.

  • August 5, 2008 at 7:18 pm

    #853579

    oh I m sorry.....u have SQLXML source in import and export wizard....

  • August 5, 2008 at 7:46 pm

    #853583

    but it ask for creating OLEDb connection, can u plz let me know how to create OLEDb connection to XML file or is ther any other easy way to import XML.

    thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply