Excel Sheet SQL Table

I have an Excel sheet. The top ro开发者_高级运维w corresponds to column names while successive rows each represent an entry.

How can I convert this Excel sheet into a SQL Table?

I am using SQL Server 2005.

That depends on which program you use for SQL . If you have SQL-Server installed. SSIS Import and Export Wizard SSIS Import and Export Wizard would be a good choice.

Use MS Access

Create a new MDB

Import the Excel file as a new table

Use the SQL Server upsizing wizard to transfer the table to SQL Server