Transferring Data from One DataGridView to Another

I am receiving an error. It says: "Syntax error in string in query expression''.

Hey ...... Fernando Sunga the mistake you are getting is, I think so very SILLY mistake that i get always while programming........ But don't get so Confused..........Just Cross VERIFY the QUERY for 4-5 times CAREfully that you are passing .........I'm sure you'll FIND that mistake by OWN........ Happy Programming.........

Hey....fernando.... you can do this by following the same procedure as I described in Article, by little change in CODE.... 1. You just have to Replace the namespace 'System.Data.SqlClient' with the 'System.Data.OleDb'. 2. And then, have to change the ConnectionString 'SqlConnection' with the ' OleDbConnection'. e.g. OleDbConnection Conn = new OleDbConnection("ProviderProvider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Northwind.accdb;Jet OLEDB:Database Password=;"); 3. Also you need to change the 'SqlDataAdaptor' with 'OleDbDataAdaptor', don't replace the 'DataSet' b'coz it is common to all data sources to store 'Temporary Data into virtual tables'. Note:- 'Microsoft.ACE.OLEDB.12.0' the Data Provider is allows to access the database files from MS ACCESS 2010

Dear Kevin, the code does not allow to insert/transfer the same Record into another table if it has PRIMARY KEY assigned for any Column

what i shouldn't do......? can you please explain.....

Did you to transfer data from NTFS File System's "master" table ??????????