Merging multiple tables question (1 Viewer)

H

hammerva

Registered User.
Local time
Today, 02:59
Joined
Dec 19, 2000
Messages
102
I have 3 tables that have the same definition and layouts. Is it possible to merge these tables into 1 complete table in Access 97?

Thanks
 
ghudson

ghudson

Registered User.
Local time
Yesterday, 21:59
Joined
Jun 8, 2002
Messages
6,195
If all of the fields are the same [properties and data type] then you can use an append query to copy records from one table into another.
 
You must log in or register to reply here.

Similar threads

H
Apprenticeship Training Matrix
2
Replies
28
Views
1,191
victorlindh
V
P
Merging/Comparing Data Between Different Excel Files
Replies
4
Views
625
Isaac
Isaac
M
Solved Crosstab report - repeating first column for multipage table
Replies
10
Views
671
Martynwheeler
M
S
Solved I used to be able to copy objects from one database to another but now I get error code 3734
2
Replies
29
Views
832
spaLOGICng
S
T
need formula \ code advice. min date
2
Replies
20
Views
370
gemma-the-husky
gemma-the-husky

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom