I need to create a Fixed-Length, Flat File, Space-Filled file. This is what I did:
1. Created a stored procedure with the fields using SPACE(#) so all the fields are the correct lenght.
2. Made a report.
3. Saved the report as Excel.
4. Save the Excel as 'Formatted Text Space Delimited'.
There are so many steps involved that I am wondering if there is a better way to create such a file.
Any help would be appreciated.
View Complete Post