How to loop data from different tables in access

[kour]

i have got six tables and i have to loop the data from these tables into different table or excel sheet.

[colintis]

Please be more specific on the question you are trying to ask, any attempts that you tried and didn't work? If so please also paste them here with the CODE Tag

[kour]

Please be more specific on the question you are trying to ask, any attempts that you tried and didn't work? If so please also paste them here with the CODE Tag

Hi,

sorry i am new to VB so i don't know the code.
I have created tables Header,Operatio n,operation text, components, Documents, and packages.
All i have to do is depending upon the ID in Header i have to retrieve operation, operation text , component ,documents and packages
I have to display this information in excel sheet or another table.

EG: I have Primary key in Header as TL0001
now i have to display all the header information related to that record then under that i have to get all the operations related to TL0001 which is stored in table called Operation.I also have to display operation text ,components, documents, packages related to these operation.

Hope that makes any sence .

Thanks for your support

[colintis]

Hi,

sorry i am new to VB so i don't know the code.
I have created tables Header,Operatio n,operation text, components, Documents, and packages.
All i have to do is depending upon the ID in Header i have to retrieve operation, operation text , component ,documents and packages
I have to display this information in excel sheet or another table.

EG: I have Primary key in Header as TL0001
now i have to display all the header information related to that record then under that i have to get all the operations related to TL0001 which is stored in table called Operation.I also have to display operation text ,components, documents, packages related to these operation.

Hope that makes any sence .

Thanks for your support

In your example case, you can make a query to run the result directly on the Operation table. After that modify the query (or make a new query) to INSERT the results into another table, this is simply SQL coding, you can try extracting the result with the query's design mode.

For extracting data into excel, my method would be simply let Access open the Excel file first, then in the excel file I extract data from Access, with VBA codes of course. In a manual way, you can export data directly in Access, but it will be annoying for keep doing that by hand clicking all the time. Some other experts might have a better idea, I leave them for this if they have.