text file database import to SQL

[Flojos1999]

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

[JHausmann]

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.

[Flojos1999]

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

[Flojos1999]

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