With VB.Net in VS2010, I'm using the IBMDA400 OLE DB connection to update an AS400 file from a dataset table that I populate from MS-Access. I fill the AS400 Dataset Table from the MS-Access table by looping through each row. After all rows have been added, I use the DataAdapter.Update(Dataset.Table) to update the Table on the AS400. It's working, but is extemely slow and I suspect it's doing individual inserts for each row (14,000 rows takes 2 hours!!). Is there a BULK INSERT method or another process that would be much faster. Thanks!