Community discussion forum

Back to discussion

Insert Records From One Ms Access table to Other Access Table

Last post was 19 Jun 2009 at 09:37
Tags: db Korea
  • 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
  • 1 year ago

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

     

    Report abuse
  • 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
  • 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
  • 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
  • 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
  • 5 months ago

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

    Report abuse
  • 5 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

Post a reply

Enter your message below

Sign in or Join us (it's free).

Ask a question

Related discussion

Quick links

Recent activity

Languages

Web Development

Frameworks & Architecture

Other major sections

Cancel
Want to stay in touch with what's going on? Follow us on twitter!