how to convert an Excel file or csv file to a fix lenhth ASCII file?

Question

How to convert an Excel file or CSV file or tab delimited text file to a fixed length ASCII file?
Thank you.

Answer 1

Open the Excel file using Office Excell and select File>saveas

and choose CSV or Tab delimited ASCII, the one you need.

Answer 2

Convert Csv To Fixed Width

Answer 3

You have to write a programm to do it, since Excell by it self is not capable of do the fix length by itself.

You can save as a CSV, and only code a program to read, and complete every column of every row, with the number required of spaces to make it fixed.

Answer 4

Export the file to SQL Server and do a Select, with the default fixed length, copy the result and you get what you want...