Loading

importing the excel xheet into sql server

ASHISH NAIKWADI

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jonathan Sterling11y ago
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.
0
Ravi Kumar12y ago
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.
+1