Excel power query is an amazing tool in excel. With Excel Power Query / Excel Power BI we can collect Tally Data in to Excel through ODBC connection. And can import Tally Live Data in to Excel. Please go through this post see how to write codes in power query to import Live Tally Data in to Excel.
If you see previous post, you observe that there we can change dates in our code only. So we need to change date etc. from our excel sheet without going in power query code. This will be simple method to collect data from Tally.
How to Connect Excel Cell Value (Date) with Power Query:
- Write Headings for Cell Value (Like : From Date and To Date)
- Fill Date below the Headings
- Select Dates with Header.
- Right Click on selected cells
- Choose Get data from Table/Range
- Click on My Table has headers and Click OK
- Now you will reach in power query code.
- In power query Dates will come with time.
- Remove time by changing datetime into Date in power query code
- After changing in Date, Right Click on From Date header – Change Type – Using Locale
- Keep Data Type Text and Locale – English and Press OK
- Repeat same process fro To Date (Right click on ToDate – Change Type – Using Locale – Text and English – OK)
- Right Click on Date and choose Add as new query
- Repeat same process for second date
- Now Change From Date and To Date name in properties (name without any space)
- Now You can use FromDate and ToDate in another power query code of this sheet.
- Like: body = Text.Replace(Text.Replace(_body, “DATE1”, FromDate), “DATE2”, ToDate),
For More clarification Please watch this video:
Ultimate Ecommerce Reconciliation
Spread the loveWith this automatic Ultimate Ecommerce Reconciliation utility we can reconcile all type E-commerce platforms (Amazon, Flipkart, Meesho, Myntra etc.) sales with there payments. We can reconcile all data order wise and stock item wise with one click. Also try Excel to Tally Ultimate Ecommerce Import This Ultimate Ecommerce Reconciliation utility has below features: … Read more
2023 Best Tally TDL to See Party Wise and Product Wise Sale Report
Spread the loveThis Tally TDL to See Party Wise and Product Wise Sale Report will help to see which item you sold more and which item you sold less. And same also can see which customer buy which items more and which customer buy which item less. We all know Tally is a popular accounting … Read more
7 Most Innovative Business Ideas (2023) You Can Start with Rs. 1 Lakh | 7 Best Businesses That Can be Started in 1 Lakh
Spread the loveStarting a business can be a daunting task, especially if you don’t have a lot of money to invest. But don’t let that discourage you. You need capital, an idea, and most importantly, the willingness to take risks and make mistakes. If you have the necessary resources, Rs. 1 lakh can be enough … Read more