how to create a table from an excel sheet?

Question

Is there an easy tutorial?

I'd like to create a table that exactly matches the excel table, is it possible to do something like "create table from excel sheet"?

Answer 1

You can use the Import and Export Wizard if you're only importing a small number of sheets.

In SQL Server Management Studio, right click on the database name, then Tasks -> Import Data. Then follow the wizard.