or
open SSMS from your computer and login to customer database with customer login credentials
2. Put All The Information
Server Type : Database Engine
Server Name : 198.
Authentication : SQL Server Authentication
Login :
Password :
3. Click connect
4. Then Write a Query
Select * from tbl_Itmdet
5. and click to Execute
This will show all the menu details
6. write click select all
again,
7. write click copy with header
then,
8. paste to Excel
9. Delete Un-necessary Column
Format should be in this format
Item , Size(Sz) , SubItem, Topping, Price, TP Price, Ex TP Price, ItmIMG, Include Indicator(Include_Ind , Choice of Indicator ( Choice_Ind), default_ind , Description
| Items | Sz | SubItem | Topping | Price | T/F Price | Ex T/F Price | ItemImage | IncludeInd | ChoiceInd | DefaultInd | Descriptions | |
10. Replace NULL
ctrl + h (for Replace )
Find: NULL
Replace : (blank)
Click Replace
11. Fixed the short form to full form
12. Item should be in Capital & sub Item should be in small .