BethanyW 9/5/2007 12:12:00 PM

Exporting SQL Data to a fixed width file

From a recent email: 

Our client needs to extract data from a variety of Dynamics GP payroll tables into a couple of files to send to their new 401 plan administrator.  The required files need to be in a fixed-width file format.  I have been thinking about possible tools that could do this job, such as SmartLists, SmartLists Builder, GP Report Writer, or perhaps a SQL view.

Your thoughts?

 

I’ve done this in the past several ways. Crystal would be the easiest – create one field that that has all the data, powered by a stored procedure. Then export the report to a text file.

 Another possibility would be just to export the data directly from a stored procedure, either via cut and paste from the query window or by running a task that will create a text file; but those options are more techincal. If you create a Crystal report, any end user can do it.

 

Version: Unknown or N/A
Section: Off Topic


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3