Greetings!

I have been attempting for the past two days to create a fast and
efficient way of importing data from a delimited text file into an
Access database.  I've (finally) found out how to get the text file
into a DataSet using the OLE DB classes and have no problems viewing
the data.  Now I cannot seem to put it into an Access database!

I've tried using various methods available to the DataSet and
DataAdapter classes and checked out many web references on how to work
with these classes.  But the references aren't of much assistance and
using the methods for the classes, while able to compile and run
successfully, does not actually put the data into the Access database!
The only way I've found to import the data is to enumerate through the
DataRows of the DataSet, create an INSERT statement from the data, and
perform the query.  Given the proported functionality of .NET, there
has to be a faster, more efficient, and above all simple way of doing
this!

Can anyone provide me with some pointers, books, or sites to assist me?
Thanks.