Roger's Download Samples - CSVtoFixed.mdb (intermediate)

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.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=361
Printed Date: 16 Apr 2024 at 1:49am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

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, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .

CSVtoFixed.mdb

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

Download
Access 97 (16 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/CSVtoFixed97.zip - CSVtoFxed97.zip
Access 2000 DAO (27 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/CSVtoFixed2k.zip - CSVtoFixed2k.zip

-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<