exporting data into text file?

[Jerome]

Hi,

I need to export my data in a very strict text format like this:

First name: 15 characters
Last name: 20 characters
Street: 20 characters
House number: 5 characters

etc

An example would be like this (the underscore symbolizing an empty space:

John___________Doe_________________Marlboro_Road_______00023

And the 2nd address would start right after the 00023:

John___________Doe_________________Marlboro_Road_______00023Jack___________Jones_______________Kentucky_Road______00088

and so on.

Is that at all possible from Access or does this need to be done
directly on the SQL Server?

Thank you,

Jerome

 

[Guest]

I would expect there is some code you could steal from Roger Carlson at
http://www.rogersaccesslibrary.com/TableOfContents3.asp

CSVtoFixed.mdb ( intermediate )
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.

 

[Jerome]

Thanks a lot! I'll look into it.

 

[Albert D. Kallal]

This is what we call a fixed length text file.

If you use the exprot wizard, and choose fixed length, you can likey
accomplish your task without any code .