G
gmazza via AccessMonster.com
Hey there,
I have been reading some of the posts about batch processing through a macro,
but each situation seems different, and obviously pertained to that person's
situation.
I would like some advice on my situation.
I need a couple processes run.
I need to Import a file from an FTP site to a table I have in my Access
database called 450Export.
I then need some code run to change values in 450Export. (Currently I have a
form with a button and on click of that button the code runs to change the
values in 450Export)
Then I need to Export this table to a folder on my server.
I need the Import to specify Delimited with a Comma.
I need the Export to specify Delimited with no Qualifiers, header row
included.
Can someone help me on this?
Thanks!
I have been reading some of the posts about batch processing through a macro,
but each situation seems different, and obviously pertained to that person's
situation.
I would like some advice on my situation.
I need a couple processes run.
I need to Import a file from an FTP site to a table I have in my Access
database called 450Export.
I then need some code run to change values in 450Export. (Currently I have a
form with a button and on click of that button the code runs to change the
values in 450Export)
Then I need to Export this table to a folder on my server.
I need the Import to specify Delimited with a Comma.
I need the Export to specify Delimited with no Qualifiers, header row
included.
Can someone help me on this?
Thanks!