Import Excel file into SQL

[Rjconrep]

I am totally new to using SQL Server so please be patient. I have ten Excel files that need to be imported into SQL server and saved out as XML files. Can anyone help me with this or at least give me direction?
Thanks

 

[nice95gle]

Seeing that you are new to SQL server I wouldn't go into the more advance topics. The best way to start with importing data is the DTS import\export wizard. You can find this in Enterprise Manager... under the server you would like to use right click on Data Transformation Services -> All Tasks -> Import Data. Then just follow the directions.

I suggest you save the package and take a look at it to see what it's doing in the background.

You can also look at BULK INSERT in T-SQL

http://msdn2.microsoft.com/en-us/library/ms188365.aspx

As for the XML part of it, you can look at the 'FOR XML AUTO' clause.
example:

select * from YOUR_TABLE_NAME [COLOR=blue]for XML auto[/color]

Well Done is better than well said
- Ben Franklin