B
Bart
Hello,
I would like to use microsoft access to modify the some base text file and
output modified file by using the information entered into the access tables.
Every row of the table would generate separate txt file.
So for example:
in the access table i would have below fields:
variable1
variable2
variable3
1. Fill all the fields in each row with the values i want.(I would enter in
manually or import it)
2. Run macro that would work like this:
-a) read all variables from row 1
-b) replace variables in the text file with variables above:
variable1 replaces $variable$ in the text file and
variable2 replaces $variable2$ in the text file and so on.
-c) save new modified file as variable1.txt
- loop through all rows and repeat above steps (a,b,c)
Is above possible? I am not an access member and i am not sure where to start?
Please help.
Bart
I would like to use microsoft access to modify the some base text file and
output modified file by using the information entered into the access tables.
Every row of the table would generate separate txt file.
So for example:
in the access table i would have below fields:
variable1
variable2
variable3
1. Fill all the fields in each row with the values i want.(I would enter in
manually or import it)
2. Run macro that would work like this:
-a) read all variables from row 1
-b) replace variables in the text file with variables above:
variable1 replaces $variable$ in the text file and
variable2 replaces $variable2$ in the text file and so on.
-c) save new modified file as variable1.txt
- loop through all rows and repeat above steps (a,b,c)
Is above possible? I am not an access member and i am not sure where to start?
Please help.
Bart