Insert Records From One Ms Access table to Other Access Table
-
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
-
Are the 2 tables in the same Access database or are they in 2 separate mdb files?
-
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.
-
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
-
just check this link which can help you in to insert data from one table to another table. Link Text
-
just check this link which can help you in to insert data from one table to another table. Click here to see example
-
good article - although in this scenario, the OP is using Access rather than SQL Server.
-
INSERT INTO tablename[(field1[, field2[, ...]])] [IN archive] _SELECT [current.]field1[, field2[, ...] _FROM tableexpression (???)
I thinks the code will work for you.
Post a reply
Quick links
Recent activity
- arif ahmad replied to How to receive data in web ...
- William Thompson replied to What is the name of the Win...
- Sameera Piyadigamage replied to Point of Sale Developers: H...
- Scott Carline replied to 4 x C# Developers for large...
- Rajendra Dhakal replied to Restore SQL Server text dat...
- cloud rainda replied to How to convert between TS f...
Enter your message below
Sign in or Join us (it's free).