Loading Excel into sqlserver

[C# Programming]

Hi,
Is it possible to load data from excel spreadsheet to sql server using c#
without giving names in column header

for example:The Spreadsheet looks like below(No Header Names)

A B C
================================
Mark Asst.Professor 25
Thomas SoftwareProfessional 30

Assiging Column Header values to sql server table called employeefields .
A = Name
B = Designation
C = Age

There will be table called Employees which contains columns such as Name,Designation,Age
Based on the fields chosen in Employeefields the records must be inserted in the Employees table in sqlserver

modified on Sunday, September 13, 2009 6:22 AM