Connection to Access DB

[Bindas]

hi
How can i Connect to Access DB like Sql SERVER DB
Right now i hav an application in C#.net windows based
now i m using sql server but right i need to Append DAta in sql server
from Access File pickup.mdb which is in local drive my first problem is
how can i creat Connection to Access file as like sql server connection
how can ?
pls give me help
ASAP
Regards
Smile

[Anthony England]

Re: Connection to Access DB

"Bindas" <deepjain1290@g mail.com> wrote in message
news:1143383272 .396983.307430@ j33g2000cwa.goo glegroups.com.. .[color=blue]
> hi
> How can i Connect to Access DB like Sql SERVER DB
> Right now i hav an application in C#.net windows based
> now i m using sql server but right i need to Append DAta in sql server
> from Access File pickup.mdb which is in local drive my first problem is
> how can i creat Connection to Access file as like sql server connection
> how can ?
> pls give me help
> ASAP
> Regards
> Smile[/color]

If you just need to get a connection, then the code will be identical except
for the connection string. So just alter the connection string for the mdb.
Look here for examples: http://www.connectionstrings.com