Excel to database table

[rmedo]

hi everybody i want to know how to convert excel sheet to database table (sqlserver database) Thanks

[andyharman]

For SQL-Server 2000 I normally use a DTS package. For 2005 you can use SSIS. Alternatively, you should be able to use the OpenRowSet function. Details of each can be found in Books-Online.

[Leyu]

Create the table with the required columns, and then use sql server import data to import your data from excel to the table you created.

[NguyenMinhCold]

Youn can use DTS control ( Import and Export data ) ... Goodluck...

NIIT