So i have this will work for each table at a time?

So if i have 200 tables I need to run this 200 time?

Thanks.

Thanks for your help. I have follwoing question.

lngRowsImported = usrServer.Databases("<DBNAME>").Tables("<TABLNAME>").ImportData(usrBcp)

Will this work for all the tables and objects in the database?

Thanks.

That will be great. Thanks.

One option would be to use Bulkcopy object of Sql DMO. If you need code sample let me know.

[/quote]