Monday, June 21, 2010

How do I export and import from MS Excel in XML format ?

MS Excel has import functionality.

You can also use SQL Server 2008 R2's (even earlier versions can be used) Import and Export Wizard.

A more generic tool and that is especially meant or Import/Export of even more complicated situations is MS SQL Server Integration Services.

The following design diagram shows roughly what you should be considering. If you use left two items you will be exporting from Excel to SQL Server and if you use the right two items you will be importing from SQL Server to Excel.

  This is all very simply explained in my book which I do recommend.

1 comment:

Alex said...

There are a lot of funny softwares which work with MS Access. But I started working with access files several days ago. And I was shocked because my data was lost. Luckily for me I was on the I-net and noticed - import batch ms sql. It resolved my trouble for a minute and without payment as I kept in mind. What is more it helped some of my friends.