Recent content by anilvaghela

The data is in access.... what i have done is appended the table from access to ms sql.... then used the table in sql to work out that procedure.... IF there is away of having that data transferred back into access database then that would be good!

Well I just want to be able to carry out the query in Access... as the sql express service is running on a client machine and i dont really want to be using sql express just to do one task....

Hello.....I have a stored procedure which does magic within MS SQL Express 2005. Off course I am only using the ms sql express software on only this one table. I want to be able to convert the following stored procedure into access...

Thanks.... i guess i can get my skates on from this point..... Thanks again!!

Thanks for that.... But how in queries to i determine what i want to do..... which is basically take the first part and find other parts from level 2,3,4 and 5 and then append them ....then loop through it again and append another group......

hello... I have a database which consists of 5 tables.... each table has the same fields but they are all linked. Table 5 - Is joined by using the parent_id field which is linked to the unique_id on Table 4 And so on.... till Table 1. Table 1 has data at level 1 on a hierarchy. So you will...

Here is an excel view of the layout of the data..... it must be in this order..... basically on the excel sheet i have placed the names and how they must sit under each level like a tree view..... basically take the first one....VISION that row will append first... then from Level 1 it will be...

i have added a screen shot of the subdatasheet which is expanded on some rows from level 1..... as u can see u_id is linked to the parent_u_id which does not show on the lower tables but i want it to append them all in this layout.....

Thanks for this.... but how do i automate this to search the records in level 2....

yes well thank you for your immediate response... basically i have 6 tables all linked together which performs different levels of information as a subdatasheet.... what i want to do is able to expand them all and able to export that view into an excel or txt file.....

i have tried linking two of the tables in connection in a query.... it does come up as a subdatasheet but when i try to export it only exports one table......

Hello! First of all i am a newbie here! Ok lets get started..... I have created a database which is a reference database for my work. I am now stuck and require help in sorting out the problem i am facing. Ok..... I have 6 tables. tbl_level1, tbl_level2 and so on till u get to tbl_level6...