| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert excel file into ASCII text file with alignment?
I am working with a medium size financial organisation. We are receiving our
bank statements in Excel Work Books. Ours is a Cobol Based programming system. We want to do our Bank Reconciliation (BRS) thorugh a program by taking the data from Bank. Our programmers wants the data in ASCII text format to do the BRS in computers. But the bank was giving the data in Excel work book as said above. I am unable to convert the same into ASCII Text file. Please help me to convert the data into ASCII Text file. Rosaiah Choudary Dodda |
|
#2
|
|||
|
|||
|
Hi Rosaiah,
File - Save As... Change the Save As Type at the bottom of the dialog to CSV Ed Ferrer http://edferrero.m6.net Our programmers wants the data in ASCII text format to do the BRS in computers. But the bank was giving the data in Excel work book as said above. I am unable to convert the same into ASCII Text file. Please help me to convert the data into ASCII Text file. Rosaiah Choudary Dodda |
|
#3
|
|||
|
|||
|
..csv files aren't aligned.
But you could try File|SaveAs|Save AS Type: Formatted Text (Space delimited)(*.prn) This is limited to 240 characters per line. And you may have to experiment with the columnwidths to get it perfect. Another option is to use your own VBA procedure to export the data the way you want. JE McGimpsey has some nice code you can borrow and enhance at: http://www.mcgimpsey.com/excel/textfiles.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Rosaiah wrote: I am working with a medium size financial organisation. We are receiving our bank statements in Excel Work Books. Ours is a Cobol Based programming system. We want to do our Bank Reconciliation (BRS) thorugh a program by taking the data from Bank. Our programmers wants the data in ASCII text format to do the BRS in computers. But the bank was giving the data in Excel work book as said above. I am unable to convert the same into ASCII Text file. Please help me to convert the data into ASCII Text file. Rosaiah Choudary Dodda -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
| How do I convert a csv file to an Excel file? | Excel Discussion (Misc queries) | |||
| How do I convert a Macintosh version 1 excel file to excel 2003 | Excel Discussion (Misc queries) | |||
| Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
