Does anyone know how to write a program using access that
reads an input file containing a string of alphanumeric
characters and writem them to an output file in a
structured (readable) format. Also, after the data is
analyst, the output file needs to be converted back to its
original format.

<(E-Mail Removed)> wrote:

>Does anyone know how to write a program using access that
>reads an input file containing a string of alphanumeric
>characters and writem them to an output file in a
>structured (readable) format. Also, after the data is
>analyst, the output file needs to be converted back to its
>original format.


Not a trivial exercise. Read up on the File I/O statements
(Open, Input, Read/Write, Get/Put, Close, etc.) in Help.
Once you're able to ewad and write the contents of the file,
the use string manipulation functions (InStr, Mid, etc) to
pull the input stream apart, and write it to the output
file.
--
Marsh
MVP [MS Access]

This is another idea. If your input file contain fixed length string and
fixed length fields, You can use File > Get External Data > Import ... to
import data into table without any coding. Prepare table with your prefer
field type and size. Access will convert data for you. For output file, You
can use File > Export and set the format of output fields.

HTH,

<(E-Mail Removed)> wrote in message
news:713b01c3e6b0$0d8e7ba0$(E-Mail Removed)...
> Does anyone know how to write a program using access that
> reads an input file containing a string of alphanumeric
> characters and writem them to an output file in a
> structured (readable) format. Also, after the data is
> analyst, the output file needs to be converted back to its
> original format.