I have 15-20 tables and i want to export the data from those tables to excel.
You can use Export Wizard.
Just right click the database and then , Wizard will open. Don't select any source let it be default. Click the next and select destination as Microsoft Excel.
This will solve your problem.