importing the excel xheet into sql server

Question

I want to import the excel sheet to sql server.while importing the data from the excel I want to create a new table dynamically in the sql server each time while uploading the excel file.The new table created has the same schema as that of excel sheet i.e column names and datatypes and all the data also copied to the new table

Ravi Kumar · Answer

hi fallow the fallowing steps. right click on your database-->tasks-->importdata-->click next--> datasource select Microsoft excel-->browse excel file-->click next--> select server name enter userid and password select database name--> click on next click on finish.

Jonathan Sterling · Answer

You can achieve this automatically without using MS Excel (actually you really should not be using MS Office on your server). Take a look at this VB.NET library for excel workbooks  it has a straightforward API for importing excel files to DataTable object . You can find more demonstration samples here .