Text file manipulation/validation

[Guest]

Hi,
The requirement are: 1. Output data from Access tables to text file. 2. Read
in an external text file, perform validation check, then update data (those
pass validation check) in the tables. The requirements seem very standard,
however, it is hard to find the sample coding handling this in Access text
book. Maybe some one can point me where i can find the sample codes......

Ps. All must be handled by programming codes, not the standard function in
Access (i.e. File.....Import/Export.....)
Howard.

 

[John Vinson]

Hi,
The requirement are: 1. Output data from Access tables to text file. 2. Read
in an external text file, perform validation check, then update data (those
pass validation check) in the tables. The requirements seem very standard,
however, it is hard to find the sample coding handling this in Access text
book. Maybe some one can point me where i can find the sample codes......

Ps. All must be handled by programming codes, not the standard function in
Access (i.e. File.....Import/Export.....)
Howard.

Take a look at the VBA Help file item on TransferText.

John W. Vinson[MVP]