narasiman rao

narasiman rao

  • NA
  • 519
  • 768.5k

Throughquery how to export the Excel data in sql server2005

Jan 1 2013 7:53 AM
i have created the excel sheet.in that sheet columns as follows;

Name DOB Mobileno Weddingday Email Active
100 of records are there in Excel.
 
i want to export that excel records into sqlserver 2005 table(DataBase)
 
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.

plese help me.