Insert data from other database to current database

htquang

New member
Local time
Today, 17:23
Joined
May 18, 2004
Messages
7
Hi,
I have 2 Access files:
1. Database file
2. LoadData file
I want to insert data from LoadData file into Database file.
Anyone can give me an idea.
Thanks
 
Hi
Do you want to upload as a one off or as a fairly regular event?
If the latter then need to ensure you do not over-write or duplicate data but if the former then it is relatively easy.
If just data tables to be imported from one to another try <File> <Get external data> <Import> or alternatively link the tables and then use a query.
If this doesn't make sense to you please come back with some more details and I will try to help further.
Best wishes

Malcy
 

Users who are viewing this thread

Back
Top Bottom