At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Hi,
Great question and there are two way export date. Please follow step by step instruction.
In the Balance sheet screen click E : Export or press Alt+E.
Select the required language from the list of Languages displayed.
Select a format from the list of Formats displayed.
By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
Press Enter to accept the default Output Sheet Name.
To update the existing file select Yes in Update Existing File.
To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
Select Yes for the Field withColour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9
Made by Microsoft, used for creating, opening and managing spreadsheet data files created with the application. Spreadsheets allow you to manipulate numbers, formulas, information and extrapolate resulting information, graphs, charts, organized lists, export data to create all sorts of useful results. Not sure what else you want to know...
Go to Gateway of Tally> Balance Sheet (Here you can choose any report which you want export in tally)
Step 1: In the Balance sheet screen click E: Export or press Alt+E.
Step 2: Select the required language from the list of languages displayed.
Step 3: Select a format from the list of formats displayed.
Step 4: By default, the exported file will be stored in C:\Program files\Tally.ERP 9 for windows 7 and C:\Tally.ERP 9 for windows XP operating systems.
Step 5: Press Enter to accept the default output sheet name.
Step 6: To update the existing file select yes in update existing file.
Step 7: To format the contents of the file selects yes in Excel (Spreadsheet) formatting.
Step 8: Select yes for the filed with color, to retain the background color in the exported file.
Step 9: Accept to export the Balance Sheet to an excel file.
Excel is a spreadsheet - it is less structured than a database and all of the data appears on one (or more) pages along with many calculations and summaries of data.
A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.
Some tasks can be performed equally well in either spreadsheet or database -
Often data is stored in a database but analysis is done in the spreadsheet.
Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.
There are two ways to get around it:
1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.
2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.
×