Merge Access Db's

[endri81]

Hi.
I am working on a project where different users send data in access db files.
I need some automation because till now I am joining this data manually and this takes me a lot of time.To be precise the files users send are the same regarding tables and forms ,only data different.
Thank you

 

[HiTechCoach]

Hi.
I am working on a project where different users send data in access db files.
I need some automation because till now I am joining this data manually and this takes me a lot of time.To be precise the files users send are the same regarding tables and forms ,only data different.
Thank you

By "joining" are you referring to writing a SQL statement?

My suspicion is that you are really wanting to append (merge) the data into a single table.

It would help if you would explain in a lot more detail what you are doing manually.

 

[endri81]

Thank you for answering.
My db contain 5 tables .All this db files from other users have 5 tables also identically the same with mines.The idea is that they enter the data to this tables through one form and then they post me all these files.I have to put all the data in my DB with the same tables.That's why I want to merge this files.
thank you

 

[HiTechCoach]

It would help if you would explain in a lot more detail what you are doing manually.

Please explain what steps you take manually to "merge the files". Be very specific like a instruction manual.

 

[endri81]

I generate reports for db files to see which records are added and then I enter them manually in my form one by one.It is a very long and boring process

 

[HiTechCoach]

I generate reports for db files to see which records are added and then I enter them manually in my form one by one.It is a very long and boring process

Oh my ... I see why you want to automate this!

It should be possible to write VBA code that would import the data from all the separate databases into a master database.

How many tables and how are they related?

 

[endri81]

There are 9 tables named:
Klinika
AbortiKryesore
Rrethet
Komunat
KomuneApoBashki
QytetApoFshat
Prefekturat
ShkalleArsimore
QytetFshatAll

First three are connected 1tomany and the others 1to1