I would like to use a macro to Import (Transfer Text File) a text file into one of my tables, then delete the text file (on my C: drive) so it won't be imported a second time by mistake. Can someone help me with this?

Thanks.

You can you the vba statement 'Kill' to delete the file. Not sure if you can do it straight from a macro...

kh

I created a function KillFile to do this task and it works fine running it from a macro.

And did you use the 'Kill' statement or did you find something else?

???
kh