hi

i have this insert query:

try
            {
                Cmd.CommandText = @"INSERT INTO BarcodTbl SELECT * FROM [Text;DATABASE=" + PathI + @"\].[Tmp.txt];";
                Cmd.ExecuteNonQuery();
                Cmd.Dispose();
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }

and i have two question:

1. how to run progress-bar from the begging to the end of the insert ?

2. if there any error i got the error exception and the action is stop -

   the query stop and the BarcodTbl is empty. how i can see the error and

   that the query will continue to fill the table ?

thank's in advance