Thursday, September 4, 2008

How to Export Data from Excel 2007 to Sql Server



1. Open MS Access and select database you want to export.
2. select database tool from menu bar. then you will see screen as below.
3. click next to create a new Data base.
4.on next screen enter credentials for sql server.
5.press Next .
The above procedure export your data base in Sql Server.