المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Excel C#



C# Programming
09-13-2009, 11:58 PM
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 Software Professional 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