Please Hep!!! I need help writing a program

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...


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.
 
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,
 
Back
Top