jaytheguru
Registered User.
- Local time
- Today, 02:56
- Joined
- Nov 13, 2007
- Messages
- 43
Dear all, I have a question regarding record importing in access 2003. I have two tables, 50,000 records on table 1 and 65,000 records in table 2 respectively.
All I want to do is to import all the records from table 2 into table 1. Hence creating only one table. Currently I am copying and pasting records from table2 into table1. As you might have figured out by now it is a pain taking process as there are alot of records to deal with.
I have tried using unmatched query option after creating table3. I thought I'll import records from table1 and 2 into one table3 but that didnt work either.
Do you have any idea how can I import records from one table to another?
The Table 1and2 both have same field names (just a thought to mention this).
Any suggestions / solutions will be greatly appreciated.
Regards
All I want to do is to import all the records from table 2 into table 1. Hence creating only one table. Currently I am copying and pasting records from table2 into table1. As you might have figured out by now it is a pain taking process as there are alot of records to deal with.
I have tried using unmatched query option after creating table3. I thought I'll import records from table1 and 2 into one table3 but that didnt work either.
Do you have any idea how can I import records from one table to another?
The Table 1and2 both have same field names (just a thought to mention this).
Any suggestions / solutions will be greatly appreciated.
Regards