Importing Part Deux

[roy_ware]

Thanks to assistance, the auto import function works great ....... Now how do
I delete the source file from the C drive from within Access? This is very
important to ensure that the user doesn't accumulate a bunch of csv files.

 

['69 Camaro]

Hi.

Now how do
I delete the source file from the C drive from within Access?

Please see the tip, "How to delete a file in VBA" on following Web page for
the syntax:

http://www.Access.QBuilt.com/html/vba.html#DelFile

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[roy_ware]

That was perfect.....and I bookmarked the page! Thank you!

 

['69 Camaro]

You're welcome! Glad it helped!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)