A
Austin
Howdy
I'm trying to write either a macro or module that I can use in access
to import data from either a .txt, .csv, .xls, or .dbf file, run batch
corrections from a predetermined list of corrections on the text
(updating/correcting addresses), and then allow me to export the file
back out in one of those aforementioned formats (preferably .csv or
..dbf). I know access can handle the file formats, but I can't seem to
find a guide on writing the macro/module. Anyone have any
hints/suggestions/sites I could utilize?
Thanks in advance
I'm trying to write either a macro or module that I can use in access
to import data from either a .txt, .csv, .xls, or .dbf file, run batch
corrections from a predetermined list of corrections on the text
(updating/correcting addresses), and then allow me to export the file
back out in one of those aforementioned formats (preferably .csv or
..dbf). I know access can handle the file formats, but I can't seem to
find a guide on writing the macro/module. Anyone have any
hints/suggestions/sites I could utilize?
Thanks in advance