Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - CSVtoFixed.mdb (intermediate)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

CSVtoFixed.mdb (intermediate)

 Post Reply Post Reply
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 20 Feb 2008
Status: Offline
Points: 261
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: CSVtoFixed.mdb (intermediate)
    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, find out why here.<
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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