How to Export ExelSheet To SqlDatabase.

Question

Hi buddy,

I am facing some problem, i want to save excel sheet in sql table but my requirement is diff..
suppose my excel file column size will be change according to that column, I want to create a table in sqlserver..
if anybody to know then please help me its very urgent

 

 

Answer 1

Import Data from excel to SQL server.
Suppose my Excel file contain 5 column according to that column i have to create a table in Sqlserver. suppose my excel sheet column size is change then again I want to create new dynamic table. if u know then replay me proper example

Answer 2

Hi Kiran,

Could you please elaborate your requirement?

Darma