Need to delete the text file at time of import.

[vvasude2]

Hi All,

I have a text file that i import from a location on my PC

eg: C:\MyTextfile.txt

I import this textfile into access using VBA. I am able to do this. What i need to add on to this is that, when i import i need to delete the file automatically from the location. ie i need to delete C:\MyTextfile.txt automatically at the time of import

Any thoughts on this is highly appreciated

-vvasude2

[TheSmileyCoder]

You simply need to add:

Kill "C:\MyTextFile.Txt"

Should you need to keep the file for audit purposes, you can use FileCopy to copy the file somewhere else first.

[ADezii]

Kill "C:\My Textfile.txt"

Oops, sorry Smiley!

[vvasude2]

Thanks both of you! worked