I got error like lis "ODBC Call Failed" when importing from access db to sql server

See more:

SQL

MS-Access

C#5.0

Hi
I got error like this 'ODBC Call Failed ' while importing db from access to sql.

I have written code like this

foreach (string tableName in tableNames)
{
//cn1 = new SqlConnection(con);
//if (cn1.State != ConnectionState.Open) { cn1.Open(); }
//SqlCommand cmd = new SqlCommand("select * into [" + tableName + "] from OPENROWSET('Microsoft.Jet.OLEDB.4.0','" + tr + "';'Admin';'',[" + tableName + "])");
//cmd.Connection = cn1;
//cmd.ExecuteNonQuery();
OleDbCommand cmd = new OleDbCommand("select * into [" + con + "].[" + tableName + "] FROM [" + tableName + "]", connection);
//OleDbCommand cmd = new OleDbCommand("select [[" + tableName + "].*] into [" + con + "].[" + tableName + "] From [" + tableName + "]");
cmd.Connection = connection;
cmd.ExecuteNonQuery();
connection.Close();
}

select * into [ODBC;Driver=SQL Server;Data Source=serverpc\sqlexpress,52120;Initial Catalog=TARUN_DB;Persist Security Info=True;User ID=vipl-user;Password=vipl-user!@#$%;MultipleActiveResultSets=True].[ClientAc] FROM [ClientAc]

If any help to resolve this error would be much appreciated.