Dear all please help i am using MC ACCESS i have 56 tables in my access database i want to creat a query in which i can see the data from all the tables into one table please note that all columns are same in all the tables right no i  am using this query

INSERT INTO
alldata select * from personal

 but this query is giving me the data for only ome table please send me complete query that give me the data for all the tables

I think what you're looking for is a view

create view myview as

select * from personal1
union
select * from personal2

etc 

 go

Yes that's correct using UNION statement but I recomend you to use UNIOL ALL

SELECT * FROM T1

UNION ALL

SELECT * FROM T2

......

UNION ALL

SELECT * FROM T56

Actually, it really depends on whether duplicates are acceptable in the result of the view.

UNION = filters out duplicates

UNION ALL = does not filter out duplicates

Why would you have 56 tables all with the same structure? Different client's info or poor design? Post the DDL of one of your tables and we could come up with the proper query fairly quickly. And, do you truly want a view of all the data or an actual table containing all the data?

hi thank you so much guys for your email and sorry for late replying actually i am telecom engineer and i have 56 different tables for 56 different BSC i have linked all bsc,s MS excel tables in MS ACCESS and then with the help of UNION commad i can see data for all the 56 tables in one table and can export to one excel sheet  thank u so much for sending me UNION command my database is working fine thanks u brothers have  a nice day

bye

aami