narasiman rao

narasiman rao

  • NA
  • 519
  • 750.6k

Through Query How to Export Excel Data to Sqlserver2005

Jan 1 2013 1:32 AM
 
  i have created the excel sheet.in that sheet columns as follows;   Excel Sheet name as Attendance Staff Details.xls

 Name  DOB  Mobileno  Weddingday  Email  Active

100 of records are there in Excel.

i want to export that excel records into sqlserver 2005 table(Data Base)

Database columns as follows.

Name DOB Mobileno Weddingday Eamil Active

Table name as BirthDayWish.


Through query how to export the excel data in to sqlserver 2005 BirthDayWish table(Database).

it is possible by using query the excel data is export from excel to BirthDayWish Table.


please help me.