I would like to know how to:

1.) import from a text file to an existing SQL database table using ADO.

2.) delete the text file after import. The text file is moved and renamed with a date and time stamp to a history folder.

3.)If an error occurs during the import then the file is moved and renamed with a date and time stamp to an error folder instead of the history folder.

Thanks for your help