Thank You Guys For The Info But I Wanted 1 More Thing

Select * From OpenRowset('MSADSQL','Driver={Microsoft dBase Driver (*.dbf)};SourceType=dbf','Select * From C:\MyApp\MyTest.Dbf')

The Command Runs Perfect

But

Select * From OpenRowset('MSADSQL','Driver={Microsoft dBase Driver (*.dbf)};SourceType=dbf','Select...

My table Is A Temp Table.After Updating the Fields,I Check The Data With Main Table And Then Delete Duplicate Data From The Temp Table.Transfer New Data From Temp To Main...

Here Is My Table -

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTemp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MyTemp]

GO

CREATE TABLE [dbo].[MyTemp] (

[TRKEY] [char] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TRDIVCOD]...

SSChampion I Got The Point The Field I Am Updating Does Have Index On It.

John Thanks

But Still I Would Like To Do It From VB.

I Dont Want DBF Files. I Just Want Package Otherwise if u want i can send my dbf at your email id.

post u r email id or mail to me...

Thank you Passchott For Your Sugesstion And Reply.

I Request You If U Can Make the Package As per U R Reply And Email Me The Same at jay_sapani@yahoo.com As i...