Macro to import and delete data

  • Thread starter Thread starter Mike Kaendera
  • Start date Start date
M

Mike Kaendera

I want to know how do you set up a macro to delete a file
after it has imported it. I have a macro that imports data
from a text file everyday. I want my the macro to only
import data once. I created a button that when you press
runs the macro. Right now if you press the button five
times it will import the data five times.I want it to
delete the data after it imports it.
 
Mike,

As far as I know, this is not possible with a macro. To delete the text
file you are importing from, you will need to use a VBA procedure using
the Kill statement.
 
Thanks steve
-----Original Message-----
Mike,

As far as I know, this is not possible with a macro. To delete the text
file you are importing from, you will need to use a VBA procedure using
the Kill statement.

--
Steve Schapel, Microsoft Access MVP


.
Click to expand...
 
Back
Top