Community discussion forum

Insert Records From One Ms Access table to Other Access Table

• • Reply

  1 year ago

  by faysal_002299

  Kamrul Hasan

  , Korea

  Joined 1 year ago

   I need to insert records from one MS Access database table to another MS Access database table.

  i'm writing the code using vb.net 2003 windows application with MS Access 2003 database.Kindly give

  me the steps to achieve this.and if possible sample code as i'm stuck somewhere in coding part.

  thank you

  regards

  chandru

   

  Report abuse
• • Reply

  1 year ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 2 years ago

  Are the 2 tables in the same Access database or are they in 2 separate mdb files?

   

  Report abuse
• • Reply

  1 year ago

  by faysal_002299

  Kamrul Hasan

  , Korea

  Joined 1 year ago

  They are in 2 different mdb files.moreover the fields wil be same in both the tables.but the 2nd table (i.e. in which i need to insert records) contains more fields than 1st one.i need to insert all the records from 1st table to 2nd table without checking for any duplicate entries.i mean there won't be any primary key..in both the tables of different database files.

  Report abuse
• • Reply

  4 months ago

  by amitbond

  Amit pathak

  delhi, India

  Joined 5 months ago

  just check this link which can help you in to insert data from one table to another table. http://aspnetans.blogspot.com/2009/06/how-to-insert-data-from-one-table-to.html

  Report abuse
• • Reply

  4 months ago

  by amitbond

  Amit pathak

  delhi, India

  Joined 5 months ago

  just check this link which can help you in to insert data from one table to another table. Link Text

  Report abuse
• • Reply

  4 months ago

  by amitbond

  Amit pathak

  delhi, India

  Joined 5 months ago

  just check this link which can help you in to insert data from one table to another table. Click here to see example

  Report abuse
• • Reply

  4 months ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 2 years ago

  good article - although in this scenario, the OP is using Access rather than SQL Server.

  Report abuse
• • Reply

  4 months ago

  by smithroy9

  smith roy

  Delhi, India

  Joined 4 months ago

  INSERT INTO tablename[(field1[, field2[, ...]])] [IN archive] _SELECT [current.]field1[, field2[, ...] _FROM tableexpression (???)

  I thinks the code will work for you.

  Report abuse