How can you convert an ACH file to an Excel file or export the ACH file to a csv file format?

Download VCF to CSV Exporter is a software which is a very fast and safe conversion tool, There is also no size limitation. It supports in window OS including XP, Vista, 8 and 10 also, you can save your file in local drive, It gives Error-free conversion from VCF to CSV format, You can try this tool.
More Info:- https://www.osttopstapp.com/vcf-to-csv.html

You can be getting an error notice when attempting to export Tally data in Excel format for a number of reasons.
You might attempt the following troubleshooting steps:

If you're trying to save the Excel file somewhere, be sure you have the right rights.
You might not have the required permissions to save the file if you are attempting to save it in a restricted place or on a network disk.
Try storing the file somewhere else, such your desktop or another folder.

Make sure you have enough space on your hard drive to save the file.It might not be possible to save the Excel file if your hard drive is full or nearly full.
Try removing unnecessary files or programs to free up some disk space.

Verify the file name and path for any special characters.
While saving the file, issues may occur if the file name or path contains special characters like slashes or colons.
Change the file's name while avoiding special characters.

Check to see if the Excel file is open already.
It might not be possible to save the file if it is open in another program or instance of Excel.
Close any open Excel windows, then try exporting the file once more.

A different format might be tried for the file's export.
Try exporting the file in an other format, such as CSV or PDF, if you are unable to save the file in Excel format.

If none of these fixes the problem, you might need to contact Tally support or your IT department for more help.

Google is your friend.

Maybe this helps convert to what you want:

https://support.office.com/en-us/article/import-contacts-from-an-excel-spreadsheet-to-outlook-f6483469-0684-4c30-82c5-c881930f5451

use the export - and select csv as the output format

The free Opal-Convert Excel to vCard to Excel might work for you. Opal Convert Excel to vCard to Excel

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.



Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.



Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,



Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

Whatever reports you want ot convert in Excel there is a command in Tally to Export File. you can select excel in export configuaratin. Even .CSV formats can also be opened in excel.
To Export File in Excel .. In tally Goto that report and press ALT+E or look for "Export Command on Tally Toolbar or left panel.

Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file