Creating a Fixed-Length, Flat File, Space-Filled file
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. Linda
October 13th, 2010 6:50pm

I'm not sure what your scenario is - why do you need an empty file like this. I'm sure you could generate such a file pretty easily with some VB.Net code... I don't believe you will find reporting services helps you a lot here (just like with excel, it will be a lot of steps...). Hope this helps, -LukaszGot a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2010 5:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics