Hi,

I have the following code in one of my projects. This code performs a bulk insert into a SQL Server table:

Dim cmdBulkInsDetails As New ADODB.Command
Set cmdBulkInsDetails.ActiveConnection = gobjDataAccess.objConn
    
With cmdBulkInsDetails
   .CommandText = "BULK INSERT ATMPOS.dbo.[TransactionDetails] From " & _
    "'" & App.Path & "\Temp\SwitchDetails.txt' " & _
    "WITH (FIELDTERMINATOR = '|',KEEPNULLS)"
   .Execute
End With

The code works just fine, but I'd like to trap for a timeout while performing the Bulk Insert - any assistance would be appreciated.

Al