By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,237 Members | 1,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,237 IT Pros & Developers. It's quick & easy.

How to loop data from different tables in access

P: 2
i have got six tables and i have to loop the data from these tables into different table or excel sheet.
Jul 13 '10 #1
Share this Question
Share on Google+
3 Replies


100+
P: 255
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
Jul 13 '10 #2

P: 2
@colintis
Hi,

sorry i am new to VB so i don't know the code.
I have created tables Header,Operation,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
Jul 13 '10 #3

100+
P: 255
@kour
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.
Jul 13 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.