Performing multiple bulkcopies for different tabels

[gshetty]

Hi,

I perform BulkCopy from Excel file to SQLServer using
DbDatatreader(o btained using OleDbConnection ). In the Dbdatareader I
actually select the entire Excel file.

I want to perform WriteToServer() in steps mapping each Column in the
Excel file to a different column in different table. However no data
is copied after the first call to WriteToServer() . I also clear the
ColumnMappings after each call to WriteToServer() . But it still does
not work.......

Regards,
gshetty