Excel to database table

Aug 26 2011 6:04 AM

i have a excel file D:\student.xlsx

the file is

admissionNo     Stdname

          100          A
          200                  B

and i want to insert the datas from excel file to database table using sql server 2008

Answers (1)

SQL server :Use variable to hold string of size greater than 8000.

Import excel to sql error