how to write connection string while connecting to MSACCESS

you are trying to connect using which programming language?

you need to create DSN for that on ur local machine.

jdbc:?????://localhost;DatabaseName=urDsName;User=uname;Password=pass

i dont know the drivername for MSACCESS but u can find from google.
put the drivername in place of ????

Again one thing....
You have to use type-I driver for that. It will be easy

Hii Amruta,
u there?

is ur problem solved??

this is exact connection string
jdbc:driver={Microsoft Access Driver (*.mdb)};DBQ='d:/srik/db1.mdb

Please find the connection string here.

hey in java ti is very specific if tthere is odbc:
connection con = DriverManager.Getconnection("Sun.Jdbc.Odbc.DAtabaseName");
what ever it is either it is ms acccess or whatever

how to convert or store the msaccess data in to the mysql