text file database import to SQL

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

1) Declare a file system object, open it, read each record and parse the data into fields. Then update your database/table either with SQL or by controls.
2) Close the object from step 1, .copy it, .delete it.
3) same as 2.

Do you have any examples.....Thanks in advance

Do you have any examples.....Thanks in advance