Tally डाटा को Excel से केसे link करे आइये जानते है /How To Link Tally Data Into Excel - Tally With GST In Hindi

Tally डाटा को Excel से केसे link करे आइये जानते है /How To Link Tally Data Into Excel

Excel se Tally data kese link kare

Dosto Tally With GST ke इससे pahli wali post me humne jaana ki Tally Data Ko Export Kese kare aasa karta hu ki aapko yeh post psand aayi hogi aur ab hum janenge ki Excel se Tally data kese link kare ODBC द्वारा Tally data ko M.S. excel me le jaane ke liye tally aur M.S. excel ko चरणबद trike se jodna hoga.Iske liye aap in steps ka use kre.

Tally data ko Excel se link karne se pahle hum yeh jaan lete h ki Tally me ODBC Server kya h Aaiye jaante h..

Tally me ODBC Server kya h
ODBC ka matlab open database connectivity se h.Yah ek programing language interface jiska use data ko aaps me ek dusre se link karne ke liye kiya jaata h.Tally.ERP9 me ODBC ka use Tally data ko kisi dusre application software per le jaane ke liye kiya jaata h.
Iske liye Tally me ODBC server aur aapke computer me MS-Query load hona आवश्यक h yadi Tally me ODBC server install h to Tally ke info panel me configration bhaag me ODBC Server likha hua hoga.Aiye ab hum jaante h ki ...

Excel se Tally data kese link kare

* Sabse phle Tally.ERP9 start kre.

* Aab us company ko select kre jiske data ko excel me import krna chahte h.yaha kewal ek hi company select honi chahiye.

* Microsoft excel open kare data menu me jaye aur From Other Sources icon pr click kre.yaha se From Microsoft Query option select kre.

* Is se data source dailogbox show hoga. 

* Yaha se Tally ODBC_9000* option select kre aur OK button per click kre.Is se query wizard ka coloum selection dialogbox show hoga.

* Yaha se Available tables and columns fild se related field select krke Columns in your query fild me le jaye.Is ke baad Next button pr click kre. Isse filter data query wizard dailogbox show hoga.

* Data ko filter krne ke baad Next button per fir se click kre. Isse sort order query wizard dailogbox show hoga.

* Is me data ka sort order set kre aur Next button per click kre. Isse query wizard ka finish dailogbox show hoga.

* Yaha se query ko save krne ke liye Save Query button per click kre.Isse save as dailogbox show hoga.Query ko save krne ke liye file ka name enter kre.Yaha se Return Data to Microsoft Office Excel option select krke Finish battan pr click kre.Isse import data dailogbox show hoga.

* Is me Tally data ko excel me import krne ka place(सेल व् शीट)निर्धारित  kre.Yadi aap tally data ko new worksheet pr import krna chahate h to new worksheet option select kre.Last me OK button per click kre .Isse tally data excel me import ho jayega.Yah data is prkar show hoga.

* Last me file ko save kre.

Excel Me Data Ko Upgrade Kese Kre:

 Tally data ko ODBC द्वारा excel me import krne ke baad aap file ko बंद kr de.Aur Tally me work krte rhe.Excel me telly data apne aap hi upgrade nahi hota.Is ke liye tally me only wahi company select kre jiske data ko excel me export kiya gaya h.

Ab excel se wahi file khole jisme tally data ko import kiya hua h.Yaha de data menu me jaye aur Refresh Data button pr click kre yaa Ctrl+Alt+F5 key ka use kre.Isse excel data apne aap hi upgrade ho jayega.Is prkar aap baar-baar tally data ko upgrade kr skte h.

Dosto Yadi Aako Hamari Yeh Post Pasand Aayi Ho To Ise Apne friends Ke Saath Jarur Share Kre Aur Aapko Tally With GST ke Baare Me Aur Adhik Information Chahiye To Hume Comment Box Me Comment Kare.
Thanks. 



Tally डाटा को Excel से केसे link करे आइये जानते है /How To Link Tally Data Into Excel Tally डाटा को  Excel से  केसे  link करे आइये जानते है /How To Link Tally Data Into Excel Reviewed by Anonymous on February 11, 2018 Rating: 5

No comments:

Powered by Blogger.