Print Page | Close Window

CSVtoFixed.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
Printed Date: 10 Jul 2020 at 8:45pm
Software Version: Web Wiz Forums 12.03 -

Topic: CSVtoFixed.mdb (intermediate)
Posted By: Roger Carlson
Subject: CSVtoFixed.mdb (intermediate)
Date Posted: 01 Aug 2008 at 6:05am

Please consider donating $1 per sample downloaded, - find out why here .


This sample reads a CSV file and exports it as a fixed width file.
Module 1 (CSVtoFixed) does the entire process in code.  For very
large records, Module 2 (CSVtoFixed2) uses a table to allow you to
create your own Export Spec.

Suppose I have this file:

Roger, Carlson, 1000.00
Susan, Carlson, 500.00
Kimberly, Carlson, 25.50

and I wanted it formatted in fixed width

Roger      Carlson       1000.00
Susan      Carlson        500.00
Kimberly   Carlson         25.50

Access 97 (16 KB): -
Access 2000 DAO (27 KB): -

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -